leetcode sql随缘打卡

262. Trips and Users
select Request_at as Day, round(count(if(Status!='completed',TRUE, Null))/count(*),2) as 'Cancellation Rate'
from Trips
where Client_Id in(select users_id from users where banned = 'No')
and Driver_Id in(select users_id from users where banned = 'No')
group by Request_at

部分代码参考了discuss    leetcode显示不对 但是用自己的mysql跑出来的应该是对的

蹭打卡一个。。。刷完easy得了。。感觉medium一下子难了许多。。加油吧！

595. Big Countries
# Write your MySQL query statement below
select name, population, area
from World
where area>3000000 or population>25000000
接下来是按照未锁的顺序 等我把没锁的都做完了再去看下怎么做锁的

kallielala 发表于 2019-6-1 04:33
蹭打卡一个。。。刷完easy得了。。感觉medium一下子难了许多。。加油吧！

加油！共勉

596. Classes More Than 5 Students
select class from
(SELECT
    class, count(DISTINCT student) as num
FROM courses
GROUP BY class)s
where num>=5

601. Human Traffic of Stadium
select stadium.id as id, stadium.visit_date as visit_date, stadium.people as people
from stadium join stadium s
on DATEDIFF(stadium.visit_date, s.visit_date) = 3
where stadium.people>100
参照197不解释

620. Not Boring Movies
select *
from cinema
where description!='boring' and id%2!=0
group by rating desc
突然发现不锁的题目没剩几道了 让我纠结一下订不订阅

626和627让我看到我的sql还有很多语法不懂 加上剩下的都锁了
所以开始学习一些sql的知识点 暂停更新

今天开始刷hackerran