编写一个 SQL 查询来查找每个日期、销售的不同产品的数量及其名称。每个日期的销售产品名称应按词典序排列。返回按 sell_date
排序的结果表。
select sell_date,count(distinct product) as num_sold ,
group_concat(distinct product order by product) as products
from Activities
group by sell_date
order by sell_date
因为这里只是找出当天卖了哪几类商品,所以count(distinct product)里有distinct;还有个小细节,添加order by product可以让商品最后显示有顺序,按照首字母排序好,便于查看。