SQL 문제 45 - LeetCode 262. Trips and Users

SQL 문제 45 - LeetCode 262. Trips and Users Trips and Users 풀이 -- ORACLE SELECT request_at AS Day ,ROUND( SUM( CASE WHEN status!='completed' THEN 1 ELSE 0 END )/COUNT(*),2) AS "Cancellation Rate" FROM Trips t WHERE request_at BETWEEN '2013-10-01' AND '2013-10-03' AND 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; -- MYSQL select request_at day, round(sum(status <> 'completed')/count(*), 2) 'Cancellati...

원문링크 : SQL 문제 45 - LeetCode 262. Trips and Users