Duck-UI テスト用サンプルデータ

1. duckui_sales_sample.csv
   - 売上明細 5,000件
   - employee_id で社員マスタとJOIN可能

2. duckui_employee_master.parquet
   - 社員マスタ 200件
   - 日本語列名・文字列・INT32・INT64を含む

Duck-UIに両ファイルをImportし、テーブル名を以下のようにすると試しやすいです。
  CSV     : sales
  Parquet : employees

--- 基本確認 ---
SELECT * FROM sales LIMIT 20;
SELECT * FROM employees LIMIT 20;

--- 部署別売上（CSV + Parquet JOIN） ---
SELECT
    e."部署",
    COUNT(*) AS "取引件数",
    SUM(s."純売上") AS "純売上合計",
    SUM(s."粗利益") AS "粗利益合計"
FROM sales AS s
JOIN employees AS e
  ON s.employee_id = e.employee_id
GROUP BY e."部署"
ORDER BY "純売上合計" DESC;

--- 事業所・部署別集計 ---
SELECT
    e."事業所",
    e."部署",
    SUM(s."純売上") AS "純売上合計"
FROM sales AS s
JOIN employees AS e
  ON s.employee_id = e.employee_id
GROUP BY e."事業所", e."部署"
ORDER BY "純売上合計" DESC;

--- 商品カテゴリ別 ---
SELECT
    "商品カテゴリ",
    COUNT(*) AS "件数",
    SUM("純売上") AS "売上",
    ROUND(AVG("純売上"), 0) AS "平均売上"
FROM sales
GROUP BY "商品カテゴリ"
ORDER BY "売上" DESC;
