统计 customers 表每一列有多少个缺失值(null)。
- 原表的每一列都要输出一行,没有缺失的列输出 0。
- 空字符串
""是一个正常的值,不算缺失。 - 表里一行都没有时,每列的缺失数都是 0。
输入
customers(customer_id, name, email, city, signup_date, tier)
输出
列为 column, null_count:column 是原表的列名(字符串),null_count 是该列 null 的个数。行顺序不限。
统计 customers 表每一列有多少个缺失值(null)。
"" 是一个正常的值,不算缺失。输入
customers(customer_id, name, email, city, signup_date, tier)输出
列为 column, null_count:column 是原表的列名(字符串),null_count 是该列 null 的个数。行顺序不限。
customers shop/customers
| # | customer_idint64 | namestring | emailstring | citystring | signup_datedate | tierstring |
|---|---|---|---|---|---|---|
| 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 |
| # | columnString | null_countInt64 |
|---|---|---|
| 1 | customer_id | 0 |
| 2 | name | 0 |
| 3 | 0 | |
| 4 | city | 8 |
| 5 | signup_date | 0 |
| 6 | tier | 11 |