leetcode

Solution to some Leetcode problems written in C++

git clone git://git.dimitrijedobrota.com/leetcode.git

0262.sql (352B)

0 SELECT request_at AS Day, 1 ROUND(AVG(status LIKE 'cancelled%'), 2) AS "Cancellation Rate" 2 FROM Trips 3 WHERE client_id IN ( 4 SELECT users_id 5 FROM Users 6 WHERE banned = 'No' 7 ) 8 AND driver_id IN ( 9 SELECT users_id 10 FROM Users 11 WHERE banned = 'No' 12 ) 13 AND request_at BETWEEN "2013-10-01" AND "2013-10-03" 14 GROUP BY request_at 15