我有以下表格
| student_id | subjects | 1 | 数学 |
|---|---|
| 英语 | |
| 数学 |
尝试使用如下示例中的APPROX_COUNT_DISTINCT
select subject, approx_count_distinct(student_id) students
from my_table t,
unnest(t.subjects) subject
group by subject