表t_sale_record为商品销售记录表，包含如下字段：
detail_id 记录ID，
sale_date 销售日期，
province 省，
city 地市，
product_id 商品ID，
cnt 数量，
amt 金额
现查询销售商品种类超过10种的省份的记录，如下哪个语句是正确的？
选项：
A:select * from t_sale_record
where province in
(select province
from t_sale_record
group by province
having count(product_id)>10)
B:select * from t_sale_record
where province in
(select province
from t_sale_record
group by province
having count(distinct product_id)>10)
C:select * from t_sale_record
where count(product_id)>10
D:select * from t_sale_record
where count(distinct product_id)>10
发布时间：2024-07-03 00:06:01
