统计状态为 'unknown' 的订单包含多少订单行、总金额是多少。
status = 'unknown' 的订单，取出它们在 order_items 里的全部订单行。cnt：这些订单行的行数。total：这些订单行的 qty × unit_price 之和（忽略折扣）。cnt = 0、total = 0（不是 null，也不是 0 行）。共享数据里根本没有 unknown 状态的订单。输入
orders(order_id, customer_id, order_ts, status, channel)order_items(order_id, product_id, qty, unit_price, discount)输出
恰好一行，列为 cnt, total。
orders shop/orders
| # | order_idint64 | customer_idint64 | order_tsdatetime | statusstring | channelstring |
|---|---|---|---|---|---|
| 1 | 1001 | 39 | 2026-01-01 19:38:00 | paid | app |
| 2 | 1002 | 16 | 2026-01-17 14:07:00 | paid | app |
| 3 | 1003 | 4 | 2026-01-08 15:40:20 | cancelled | web |
| 4 | 1004 | 2 | 2026-05-23 10:48:58 | paid | null |
| 5 | 1005 | 12 | 2026-06-22 11:07:22 | paid | store |
| 6 | 1006 | 17 | 2026-08-15 05:15:25 | paid | web |
| 7 | 1007 | 9 | 2026-06-11 01:00:32 | refunded | store |
| 8 | 1008 | 45 | 2026-09-19 20:47:10 | paid | web |
| 9 | 1009 | 2 | 2025-10-05 04:53:38 | paid | app |
| 10 | 1010 | 4 | 2026-02-19 01:39:54 | paid | app |
| 11 | 1011 | 28 | 2026-03-05 03:04:45 | refunded | store |
| 12 | 1012 | 2 | 2026-08-01 07:09:17 | paid | web |
| 13 | 1013 | 26 | 2026-01-22 03:48:14 | refunded | store |
| 14 | 1014 | 2 | 2026-02-09 01:41:41 | paid | app |
| 15 | 1015 | 5 | 2026-08-03 19:49:04 | refunded | web |
| 16 | 1016 | 26 | 2026-02-16 00:43:43 | refunded | app |
| 17 | 1017 | 9 | 2025-12-06 04:48:57 | pending | app |
| 18 | 1018 | 999 | 2026-05-19 12:13:43 | paid | store |
| 19 | 1019 | 26 | 2026-02-05 15:02:26 | paid | store |
| 20 | 1020 | 44 | 2025-11-24 11:19:00 | cancelled | web |
order_items shop/order_items
| # | order_idint64 | product_idint64 | qtyint64 | unit_pricefloat64 | discountfloat64 |
|---|---|---|---|---|---|
| 1 | 1001 | 22 | 3 | 298.8 | null |
| 2 | 1001 | 26 | 1 | 190.0 | 0.1 |
| 3 | 1002 | 6 | 2 | 254.2 | 0.0 |
| 4 | 1002 | 9 | 3 | 79.0 | null |
| 5 | 1002 | 19 | 5 | 305.1 | 0.2 |
| 6 | 1003 | 9 | 2 | 79.0 | 0.1 |
| 7 | 1003 | 28 | 2 | 47.4 | 0.0 |
| 8 | 1004 | 5 | 1 | 500.0 | 0.1 |
| 9 | 1005 | 3 | 1 | 89.0 | 0.0 |
| 10 | 1005 | 12 | 4 | 45.0 | null |
| 11 | 1006 | 13 | 1 | 19.9 | 0.1 |
| 12 | 1006 | 25 | 2 | 39.9 | null |
| 13 | 1007 | 27 | 1 | 12.5 | null |
| 14 | 1008 | 3 | 1 | 89.0 | null |
| 15 | 1008 | 16 | 1 | 29.9 | null |
| 16 | 1008 | 17 | 1 | 129.0 | null |
| 17 | 1009 | 2 | 1 | 49.9 | 0.0 |
| 18 | 1009 | 10 | 2 | 42.5 | null |
| 19 | 1009 | 20 | 1 | 84.5 | 0.05 |
| 20 | 1010 | 1 | 1 | 23.8 | 0.1 |
| # | cntInt64 | totalFloat64 |
|---|---|---|
| 1 | 0 | 0.0 |