![](https://img-blog.csdnimg.cn/20190927151043371.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
SQL刷题-leetcode
文章平均质量分 64
菜狗leetcode刷题
你说你是哪块小饼干?
这个作者很懒,什么都没留下…
展开
-
SQL刷题
Leetcode1098. 不受欢迎的书(中等)SUM(IF(o.quantity IS NULL,0,o.quantity))<10 包含判空的条件SELECT B.book_id,B.name from books as B LEFT JOIN orders2 as OON (B.book_id=O.book_id and O.dispatch_date BETWEEN date('2018-06-23') and DATE('2019-06-23') )WHERE B.avai...原创 2021-06-24 21:49:20 · 52 阅读 · 0 评论 -
Sql 刷题
周日刷题就问还有谁group by 多值详细解释https://blog.csdn.net/weixin_38750084/article/details/82780519增加一行自增列数值ROW_NUMBER() over()select ROW_NUMBER() over(),a,b,c from testSELECT b ,c,count(a) from testGROUP BY b ,cLeetcode579. 查询员工的累计薪水(困难)找来找去不会写 感叹大佬的分享...原创 2021-06-30 13:53:36 · 66 阅读 · 0 评论 -
SQL刷题-3
贵公子范昨晚吃了凉的水果捞 腹泻一整晚酸爽无比Leetcode607.销售员(简单)SELECT * from salesperson as spLEFT JOIN orders1 as oon (sp.sales_id=o.sales_id)LEFT JOIN company as con (c.com_id=o.com_id)GROUP BY sp.sales_idHAVING sum(if(c.`NAME`='red',1,0))=0Leetcode610. 判断三角形(简单.原创 2021-06-22 21:30:18 · 95 阅读 · 0 评论 -
SQL刷题+java复习
Leetcode570. 至少有5名直接下属的经理(中等)SELECT e1.name from(SELECT ManagerId from employee2GROUP BY ManagerIdHAVING count(ManagerId )>=5) as e2left join employee2 as e1on e1.id =e2.ManagerId原创 2021-06-25 20:59:48 · 66 阅读 · 0 评论 -
SQL刷题-2
贫穷贵公子范下午上完英语困得要死,头疼依旧刷题,今天也是丢人的一天长沙碗底挑面馆?长沙风味但是不辣,一个路过可以去试试但是不是很好吃的面馆Leetcode597. 好友申请 I :总体通过率(简单)selectround( ifnull( (select count(*) from (select distinct requester_id, accepter_id from request_accepted) as A) / (select count(*) ...原创 2021-06-21 19:23:54 · 93 阅读 · 2 评论 -
SQL刷题记录
今天又是贫穷贵公子刷题的一天没脑子的贵公子能刷什么,刷sql啦,为了当数据分析狮努力啦SELECT tmp.customer_numberfrom(SELECT customer_number,DENSE_RANK() over(order by count(order_number) desc) as rkfrom ordersGROUP BY customer_number) tmpwhere tmp.rk=1...原创 2021-06-20 20:57:45 · 65 阅读 · 0 评论 -
SQL刷题+Java急救
Scanner java.util包提供的一个类 使用前导入该包 char ch = 'k'; System.out.println("请输入单个字符"); try { ch = (char) System.in.read(); } catch (IOException e) { e.printStackTrace(); } System.out.println原创 2021-07-02 11:38:07 · 120 阅读 · 3 评论