SQL刷题记录

今天又是贫穷贵公子刷题的一天呢

没脑子的贵公子能刷什么，刷sql啦，为了当数据分析狮努力啦

复制粘贴好累，打字好累，好想颓废

贵公子刷了三道sql?然后要做六级听力 然后看深度学习

Leetcode586. 订单最多的客户（简单）

SELECT tmp.customer_number
from
(SELECT customer_number,
DENSE_RANK() over(order by count(order_number) desc) as rk
from orders
GROUP BY customer_number)  tmp
where tmp.rk=1