第17关 having

查询订单详情表lineitem中商品购买总数量超过6件的订单编号orderid、商品编号itemid和购买总数sum(quantity) as total。按购买总数total从大到小排列。

查询订单详情表lineitem中...

select ？？？ from lineitem

商品购买总数量...

sum(quantity)

超过6件...

having sum(quantity)>6

的订单编号orderid、商品编号itemid和购买总数sum(quantity) as total。

select orderid,itemid,sum(quantity) as total

按购买总数total从大到小排列。

order by total desc

最后把这些玩意组装起来就是了。

select orderid,itemid,sum(quantity) as total 
from lineitem 
group by orderid,itemid  
having sum(quantity)>6 
order by total desc

sql是最接近自然语言的开发语言之一，记熟一些关键词，简单的场景直接翻译一下就差不多了

从你的描述，我提取出信息：订单详情表有字段：订单编号（orderid）、商品编号（itemid）,数量（quantity）。
sql语句为如下：

select orderid,itemid,sum(quantity) as total from lineitem 
group by orderid,itemid
having total>6
order by total desc;

如果解决问题，请点个采纳