运行模式：离线规则（限定明确问法）。所有 SQL 均经过统一安全守护；本报告不依赖外部 CDN、脚本或浏览器存储。
01
总销售额是多少？
汇总匹配订单的总销售额、总销量和订单数。 返回 1 行。
查看生成并实际执行的 SQL
SELECT ROUND(COALESCE(SUM(revenue), 0), 2) AS total_revenue, COALESCE(SUM(quantity), 0) AS total_quantity, COUNT(*) AS order_count FROM orders LIMIT 200| total_revenue | total_quantity | order_count |
|---|---|---|
| 612360.0 | 1178 | 48 |
02
按类别销售额排行
按商品类别汇总销售额和销量，并按销售额降序排行。 返回 4 行。
查看生成并实际执行的 SQL
SELECT category, ROUND(SUM(revenue), 2) AS total_revenue, SUM(quantity) AS total_quantity FROM orders GROUP BY category ORDER BY total_revenue DESC, category ASC LIMIT 200| category | total_revenue | total_quantity |
|---|---|---|
| 智能家居 | 212287.0 | 341 |
| 厨房电器 | 178983.0 | 248 |
| 运动户外 | 129523.0 | 307 |
| 个护健康 | 91567.0 | 282 |
03
按月销售趋势
按订单月份汇总销售额与销量，并按时间升序展示趋势。 返回 6 行。
查看生成并实际执行的 SQL
SELECT substr(order_date, 1, 7) AS month, ROUND(SUM(revenue), 2) AS total_revenue, SUM(quantity) AS total_quantity FROM orders GROUP BY month ORDER BY month ASC LIMIT 200| month | total_revenue | total_quantity |
|---|---|---|
| 2025-01 | 94010.0 | 183 |
| 2025-02 | 109964.0 | 209 |
| 2025-03 | 106449.0 | 204 |
| 2025-04 | 98294.0 | 199 |
| 2025-05 | 103379.0 | 194 |
| 2025-06 | 100264.0 | 189 |
04
按地区销售额
按地区汇总销售额和销量，并按销售额降序排列。 返回 4 行。
查看生成并实际执行的 SQL
SELECT region, ROUND(SUM(revenue), 2) AS total_revenue, SUM(quantity) AS total_quantity FROM orders GROUP BY region ORDER BY total_revenue DESC, region ASC LIMIT 200| region | total_revenue | total_quantity |
|---|---|---|
| 华南 | 168507.0 | 321 |
| 华东 | 160672.0 | 299 |
| 华北 | 146972.0 | 299 |
| 西南 | 136209.0 | 259 |
05
销量最高的商品类别是什么？
按商品类别汇总销量，并返回销量最高的类别。 返回 1 行。
查看生成并实际执行的 SQL
SELECT category, SUM(quantity) AS total_quantity, ROUND(SUM(revenue), 2) AS total_revenue FROM orders GROUP BY category ORDER BY total_quantity DESC, category ASC LIMIT 1| category | total_quantity | total_revenue |
|---|---|---|
| 智能家居 | 341 | 212287.0 |
06
哪个渠道销量最高？
按销售渠道汇总销量，并返回销量最高的渠道。 返回 1 行。
查看生成并实际执行的 SQL
SELECT channel, SUM(quantity) AS total_quantity, ROUND(SUM(revenue), 2) AS total_revenue FROM orders GROUP BY channel ORDER BY total_quantity DESC, channel ASC LIMIT 1| channel | total_quantity | total_revenue |
|---|---|---|
| 天猫 | 323 | 183187.0 |
07
各渠道销售额对比
按销售渠道汇总销售额和销量，便于横向对比。 返回 4 行。
查看生成并实际执行的 SQL
SELECT channel, ROUND(SUM(revenue), 2) AS total_revenue, SUM(quantity) AS total_quantity FROM orders GROUP BY channel ORDER BY total_revenue DESC, channel ASC LIMIT 200| channel | total_revenue | total_quantity |
|---|---|---|
| 天猫 | 183187.0 | 323 |
| 线下门店 | 169172.0 | 297 |
| 京东 | 139350.0 | 300 |
| 抖音 | 120651.0 | 258 |
08
各产品线销售额
按 products 维度的产品线汇总订单销售额和销量。 返回 4 行。
查看生成并实际执行的 SQL
SELECT p.product_line AS product_line, ROUND(SUM(o.revenue), 2) AS total_revenue, SUM(o.quantity) AS total_quantity FROM orders o JOIN products p ON o.category = p.category GROUP BY p.product_line ORDER BY total_revenue DESC, product_line ASC LIMIT 200| product_line | total_revenue | total_quantity |
|---|---|---|
| 智能家居 | 212287.0 | 341 |
| 厨房烹饪 | 178983.0 | 248 |
| 运动健康 | 129523.0 | 307 |
| 个人护理 | 91567.0 | 282 |
09
各渠道类型销售额
按 channels 维度的渠道类型汇总订单销售额和销量。 返回 4 行。
查看生成并实际执行的 SQL
SELECT c.channel_type AS channel_type, ROUND(SUM(o.revenue), 2) AS total_revenue, SUM(o.quantity) AS total_quantity FROM orders o JOIN channels c ON o.channel = c.channel GROUP BY c.channel_type ORDER BY total_revenue DESC, channel_type ASC LIMIT 200| channel_type | total_revenue | total_quantity |
|---|---|---|
| 平台电商 | 183187.0 | 323 |
| 线下零售 | 169172.0 | 297 |
| 自营电商 | 139350.0 | 300 |
| 内容电商 | 120651.0 | 258 |