data_yep

[문제]  [MySQL]SELECT nameFROM CustomerWHERE referee_id != 2 OR referee_id IS NULL

[문제]  [MySQL]SELECT e.name , b.bonusFROM Employee AS e LEFT JOIN Bonus AS b ON e.empId = b.empIdWHERE b.bonus

[문제]  [MySQL]SELECT m.nameFROM Employee AS e INNER JOIN Employee AS m ON e.managerId = m.idGROUP BY m.idHAVING COUNT(DISTINCT e.id) >= 5

[문제]  [MySQL]WITH first_event AS ( SELECT player_id , MIN(event_date) AS first_date FROM Activity GROUP BY player_id)SELECT ROUND(COUNT(DISTINCT CASE WHEN a.event_date = DATE_ADD(f.first_date, INTERVAL 1 DAY) THEN a.player_id END) / COUNT(DISTINCT a.player_id), 2) AS fractionFROM Activity AS a INNER JOIN first_event AS f ON a.player_id = f.player_id

[문제]  [MySQL]SELECT player_id , event_date AS first_loginFROM ( SELECT * , ROW_NUMBER () OVER (PARTITION BY player_id ORDER BY event_date) AS row_n FROM Activity) AS player_loginWHERE row_n = 1

[문제]  [MySQL]WITH Clients AS ( SELECT * FROM Users WHERE role = 'client') , Drivers AS ( SELECT * FROM Users WHERE role = 'driver')SELECT t.request_at AS Day , ROUND(COUNT(DISTINCT CASE WHEN t.status != 'completed' THEN t.id END) / COUNT(DISTINCT t.id), 2) AS 'Cancellation Rate'FROM Trips AS t INNER JOIN Clients AS c ON t.client_id = c.users_id..

[문제]  [MySQL]WITH record_list AS ( SELECT W1.* , W2.recordDate AS yesterday , W2.temperature AS temperature_yesterday FROM Weather AS W1 LEFT JOIN Weather AS W2 ON W1.recordDate = DATE_ADD(W2.recordDate, INTERVAL 1 DAY))SELECT id AS IdFROM record_listWHERE temperature > temperature_yesterday

[문제]  [MySQL]DELETE p1FROM Person AS p1 LEFT JOIN Person AS p2 ON p1.email = p2.emailWHERE p1.id > p2.id

[문제]  [MySQL]WITH salary_rank AS ( SELECT * , DENSE_RANK() OVER (PARTITION BY departmentId ORDER BY salary DESC) AS dense_rk FROM Employee)SELECT d.name AS Department , sr.name AS Employee , sr.salary AS SalaryFROM salary_rank AS sr LEFT JOIN Department AS d ON sr.departmentId = d.idWHERE sr.dense_rk

[문제]  [MySQL]WITH highest_salary AS ( SELECT * , MAX(salary) OVER (PARTITION BY departmentId ORDER BY salary DESC) AS highest_salary FROM Employee)SELECT d.name AS Department , hs.name AS Employee , hs.salary AS SalaryFROM highest_salary AS hs LEFT JOIN Department AS d ON hs.departmentId = D.idWHERE hs.salary = hs.highest_salary