Jerry의 컴퓨터 일기

https://leetcode.com/problems/trips-and-users/description/🗒️SQL 코드 풀이 1SELECT T1.request_at AS Day, ROUND( SUM(CASE WHEN status = "completed" THEN 0 ELSE 1 END) / COUNT(*),2) AS "Cancellation Rate" FROM Trips T1 LEFT JOIN Users U1 ON T1.client_id= U1.users_id LEFT JOIN Users U2 ON T1.driver_id= U2.users_id WHERE U1.banned "YES" AND U2.banned "YES" ..

https://leetcode.com/problems/department-top-three-salaries/description/🗒️SQL 코드 풀이 1SELECT D1.name AS Department , E1.name AS Employee , E1.salary AS Salary FROM ( SELECT *, DENSE_RANK() OVER (PARTITION BY departmentId ORDER BY salary DESC) AS salaryRank FROM Employee ) E1 INNER JOIN Department D1 ON E1.departmentId = D1.id WHERE E1.salaryRank  ..