df-drills pandas · Polars · DuckDB SQL · DuckDB Relational 题目列表 登录

时间范围

简单 02-filter 过滤 filterdatetimerangeboundary

找出 2026 年 3 月下的订单。

  • 时间区间为左闭右开 [2026-03-01 00:00:00, 2026-04-01 00:00:00):恰好 2026-03-01 00:00:00 的订单要,恰好 2026-04-01 00:00:00 的订单不要。
  • 2026-03-31 当天的订单全天都算,包括 23:59:59.999999 这种带微秒的时间。
  • 只看 2026 年:其他年份的 3 月订单不要。
  • order_ts 不带时区。

输入

  • orders(order_id, customer_id, order_ts, status, channel)

输出

保留订单表的全部列:order_id, customer_id, order_ts, status, channel,行顺序不限。

输入表 (case base,共 2 个 case:base、edges)

orders shop/orders
#order_idint64customer_idint64order_tsdatetimestatusstringchannelstring
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
显示前 20 行,共 200 行

期望输出 (case base,行顺序不限)

#order_idInt64customer_idInt64order_tsDatetime(time_unit='us', time_zone=None)statusStringchannelString
1 1011 28 2026-03-05 03:04:45 refunded store
2 1029 18 2026-03-03 14:01:10 paid web
3 1037 38 2026-03-08 19:28:41 pending store
4 1051 12 2026-03-01 00:00:00 paid web
5 1053 12 2026-03-31 23:59:59 paid web
6 1077 49 2026-03-12 11:45:00 paid app
7 1092 43 2026-03-21 08:38:21 paid web
8 1116 29 2026-03-03 06:48:10 paid app
9 1121 1 2026-03-04 08:46:39 cancelled app
10 1141 null 2026-03-25 08:24:00 cancelled store
11 1188 32 2026-03-10 07:26:29 refunded store
12 1189 5 2026-03-29 08:53:58 pending store
共 12 行