# LeetCode Database - Easy 刷题记录【完结】

4 篇文章 0 订阅

8/14/20201527 Patients With a ConditionLIKE
8/14/20201350 Students With Invalid DepartmentsNOT IN
8/14/20201303 Find the Team SizeGROUP BY

8/15/20201378 Replace Employee ID With The Unique IdentifierLEFT JOIN
8/15/20201484 Group Sold Products By The DateDISTINCT

8/15/20201068 Product Sales Analysis ILEFT JOIN
8/15/20201069 Product Sales Analysis IIGROUP BY
8/15/20201407 Top Travellers空值转为0的方法：
IFNULL(字段,0)
coalesce(字段,0)
8/16/20201251 Average Selling PriceROUND( , )

8/16/2020511 Game Play Analysis IMIN()
8/16/20201179 Reformat Department Table两种方法：
CASE WHEN THEN END
IF(条件,满足条件返回的,不满足条件返回的)

8/16/20201173 Immediate Food Delivery IIF也太好用了！！！
8/16/2020613 Shortest Distance in a Line绝对值ABS()
8/16/2020595 Big Countries总得来说，数清楚有多少个0别写错就行
8/16/20201511 Customer Order Frequency

MySQL中提取日期中的年月日：YEAR() MONTH() DAY()
8/16/20201435 Create a Session Bar Chart
UNION
8/16/20201327 List the Products Ordered in a Period注意筛选顺序
8/16/20201148 Article Views I好好读题
8/17/2020586 Customer Placing the Largest Number of OrdersLIMIT
8/17/20201517 Find Users With Valid E-MailsMySQL 正则表达式
8/17/20201280 Students and Examinations注意表别名
8/17/2020584 Find Customer RefereeIS NULL
8/17/20201082 Sales Analysis I题出的奇奇怪怪的，刚开始还以为要算利润，一番操作发现跟Products表半毛钱关系都没有= =
8/18/20201050 Actors and Directors Who Cooperated At Least Three TimesGROUP BY
8/18/20201543 Fix Product Name Format这里由于原表和输出表用了一样的列名，如果GROUP BY和ORDER BY中直接写列名的话，会引起混淆从而报错，所以这里要换成位置(1,2)代指
8/18/20201211 Queries Quality and PercentageAVG()
8/18/2020577 Employee BonusIS NULL
8/18/2020620 Not Boring Movies奇数%2=1
8/19/20201241 Number of Comments per Post原表应一分为二（NULL），注意筛选顺序及JOIN的方式
8/19/2020610 Triangle Judgement两边之和大于第三边
8/19/20201075 Project Employees I ROUND
8/19/20201113 Reported Posts注意审题，DISTINCT
8/19/2020603 Consecutive Available SeatsSELF JOIN
8/20/20201294 Weather Type in Each CountryCASE WHEN
8/20/2020607 Sales PersonNOT IN
INNER JOIN
8/20/2020182 Duplicate Emails筛选重复值的方法
8/20/2020175 Combine Two TablesLEFT JOIN
8/21/2020181 Employees Earning More Than Their Managers
8/21/2020512. Game Play Analysis II
8/21/20201084 Sales Analysis III本题的难点是“only”，也就是说它不仅要在1-3月售出，还要在其他月都不售出。还有更简便的方法是用MAX()<和MIN()>来限制
8/21/20201141 User Activity for the Past 30 Days I
8/21/2020183 Customers Who Never Order

8/21/2020 - 8/23/2020，这两天无法描述，概括来说就是三天八场笔试，可怜的我还是时差党，每天都头晕脑涨的。八场笔试的总结是，目前我的SQL处在一个AC没问题，花费时间也不长的阶段了。个人感觉牛客题目刷了两遍还是很有用的，当然也感谢研一时那个韩国教授，虽然他让我的成绩单从全A多了一个A-，但是基础真的是他打牢的。 马上LeetCode Database - Easy系列就要结束了，接下来会每天做三道Medium保持手感，重点会转移到算法上，目前准备完成的是LeetCode Easy系列+《剑指Offer》。

The city every dream can stay

8/24/20201076 Project Employees IILIMIT
8/24/20201495 Friendly Movies Streamed Last MonthDISTINCT
8/24/20201083 Sales Analysis II
8/24/2020619 Biggest Single Number
8/24/2020196 Delete Duplicate Emails
8/25/2020597 Friend Requests I: Overall Acceptance RateIFNULL
COUNT
8/25/2020197 Rising TemperatureDATEDIFF()
8/25/2020596 Classes More Than 5 StudentsDISTINCT
8/25/20201142 User Activity for the Past 30 Days II
8/25/2020176 Second Highest Salary

• 0
点赞
• 0
评论
• 0
收藏
• 打赏
• 扫一扫，分享海报

10-01 6万+
10-08 827
12-05 74
05-06 237
10-31 65
01-24 103
01-24 105
01-23 574

Yating260

¥2 ¥4 ¥6 ¥10 ¥20

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、C币套餐、付费专栏及课程。