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

在列表中

简单 02-filter 过滤 filterisinNone

找出所在城市是 Beijing、Shanghai、Shenzhen 三者之一的客户。

  • 精确匹配,区分大小写,不做去空格处理:beijing、Beijing 都不算。
  • city 为 null 的客户不属于任何城市,不输出。

输入

  • customers(customer_id, name, email, city, signup_date, tier)

输出

保留客户表的全部列:customer_id, name, email, city, signup_date, tier,行顺序不限。

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

customers shop/customers
#customer_idint64namestringemailstringcitystringsignup_datedatetierstring
1 1 Fang Wang fang.wang@shop.io Beijing 2025-03-13 silver
2 2 Dana Xu dana.xu@mail.cn null 2025-02-17 silver
3 3 Li Zhou li.zhou@example.com Guangzhou 2025-10-07 bronze
4 4 Ping Wang ping.wang@example.com null 2025-05-23 gold
5 5 Tom Zhang tom.zhang@example.com Shenzhen 2025-06-26 gold
6 6 王芳 user06@shop.io Hangzhou 2025-02-10 gold
7 7 Victor Xu victor.xu@example.com Shanghai 2025-12-05 bronze
8 8 Dana Chen dana.chen@example.com Hangzhou 2025-11-22 bronze
9 9 Uma Chen uma.chen@shop.io Guangzhou 2025-11-28 null
10 10 Ivy Zhou ivy.zhou@shop.io Hangzhou 2025-07-14 gold
11 11 Mia Smith mia.smith@mail.cn Shanghai 2025-04-28 gold
12 12 Xin Yang xin.yang@example.com Chengdu 2026-01-03 silver
13 13 Xin Smith xin.smith@mail.cn Beijing 2025-05-07 silver
14 14 Zoe Xu zoe.xu@mail.cn Beijing 2025-09-18 silver
15 15 Fang Liu fang.liu@shop.io Guangzhou 2025-08-05 bronze
16 16 杨磊 user16@mail.cn Shanghai 2025-12-15 silver
17 17 Ping Smith ping.smith@mail.cn null 2025-08-11 bronze
18 18 Oscar Zhou oscar.zhou@example.com Shanghai 2025-11-17 null
19 19 Kevin Liu kevin.liu@mail.cn Chengdu 2026-02-03 gold
20 20 Sara Wu sara.wu@example.com null 2025-07-05 gold
显示前 20 行,共 50 行

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

#customer_idInt64nameStringemailStringcityStringsignup_dateDatetierString
1 1 Fang Wang fang.wang@shop.io Beijing 2025-03-13 silver
2 5 Tom Zhang tom.zhang@example.com Shenzhen 2025-06-26 gold
3 7 Victor Xu victor.xu@example.com Shanghai 2025-12-05 bronze
4 11 Mia Smith mia.smith@mail.cn Shanghai 2025-04-28 gold
5 13 Xin Smith xin.smith@mail.cn Beijing 2025-05-07 silver
6 14 Zoe Xu zoe.xu@mail.cn Beijing 2025-09-18 silver
7 16 杨磊 user16@mail.cn Shanghai 2025-12-15 silver
8 18 Oscar Zhou oscar.zhou@example.com Shanghai 2025-11-17 null
9 25 张伟 user25@example.com Shanghai 2025-06-23 null
10 27 Amy Huang amy.huang@example.com Shenzhen 2025-12-09 silver
11 28 Nina Wu nina.wu@mail.cn Shanghai 2025-12-04 bronze
12 29 Bob Smith bob.smith@shop.io Shanghai 2025-02-01 bronze
13 41 Lin Zhou lin.zhou@mail.cn Shenzhen 2025-02-05 bronze
14 43 Rui Smith rui.smith@example.com Beijing 2025-05-16 null
15 44 Eric Lee eric.lee@shop.io Shenzhen 2025-11-06 bronze
16 45 Oscar Wang RUI.CHEN@EXAMPLE.COM Shenzhen 2025-01-23 null
17 49 Lin Smith lin.smith@example.com Shenzhen 2026-02-04 gold
18 50 Hao Chen hao.chen@example.com Beijing 2025-07-31 null
共 18 行