#104. [LeetCode / MySQL] 1731. The Number of Employees Which Report to Each Employee

문제 입력 코드 SELECT e2.employee_id, e2.name, COUNT(*) AS reports_count, ROUND(AVG(e1.age)) AS average_age FROM Employees AS e1 INNER JOIN Employees AS e2 ON e1.reports_to = e2.employee_id GROUP BY e2.employee_id, e2.name ORDER BY e2.employee_id 코드 설명 #SELECT #COUNT #ROUND #AVG #INNER JOIN #GROUP BY #ORDER BY 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your codi..

• format_list_bulleted SQL
• · 2023. 9. 30.
• textsms

#96. [LeetCode / MySQL] 550. Game Play Analysis IV

문제 입력 코드 SELECT ROUND(COUNT(DISTINCT player_id)/(SELECT COUNT(DISTINCT player_id) FROM Activity), 2) AS fraction FROM Activity WHERE (player_id, DATE_SUB(event_date, INTERVAL 1 DAY)) IN ( SELECT player_id, MIN(event_date) AS first_login FROM Activity GROUP BY player_id ) 코드 설명 #SELECT #ROUND #COUNT #DISTINCT #DATE_SUB #INTERVAL #MIN #GROUP BY 문제 출처 Game Play Analysis IV - LeetCode Can you solve ..

• format_list_bulleted SQL
• · 2023. 9. 22.
• textsms

#95. [LeetCode / MySQL] 1174. Immediate Food Delivery II

문제 입력 코드 SELECT ROUND(AVG(order_date = customer_pref_delivery_date) * 100, 2) AS immediate_percentage FROM Delivery WHERE (customer_id, order_date) IN ( SELECT customer_id, MIN(order_date) FROM Delivery GROUP BY customer_id ) 코드 설명 #SELECT #ROUND #AVG #MIN #GROUP BY #SUBQUERY 문제 출처 Immediate Food Delivery II - LeetCode Can you solve this real interview question? Immediate Food Delivery II - Tabl..

• format_list_bulleted SQL
• · 2023. 9. 21.
• textsms

#93. [LeetCode / MySQL] 1211. Queries Quality and Percentage

문제 입력 코드 1. IF SELECT query_name, ROUND(AVG(rating/position), 2) AS quality, ROUND(AVG(IF(rating < 3, 1, 0))*100, 2) AS poor_query_percentage FROM Queries GROUP BY query_name 2. CASE WHEN SELECT query_name, ROUND(AVG(rating/position), 2) AS quality, ROUND(SUM( CASE WHEN rating < 3 THEN 1 ELSE 0 END ) * 100 / COUNT(*), 2) AS poor_query_percentage FROM Queries GROUP BY query_name 코드 설명 #SELECT #RO..

• format_list_bulleted SQL
• · 2023. 9. 19.
• textsms

#92. [LeetCode / MySQL] 1633. Percentage of Users Attended a Contest

문제 입력 코드 SELECT contest_id, ROUND(COUNT(DISTINCT user_id)/(SELECT COUNT(user_id) FROM Users) * 100, 2) AS percentage FROM Register GROUP BY contest_id ORDER BY percentage DESC, contest_id ASC; 코드 설명 #SELECT #ROUND #COUNT #DISTINCT #GROUP BY #ORDER BY 문제 출처 Percentage of Users Attended a Contest - LeetCode Can you solve this real interview question? Percentage of Users Attended a Contest - Table:..

• format_list_bulleted SQL
• · 2023. 9. 18.
• textsms

#91. [LeetCode / MySQL] 1075. Project Employees I

문제 입력 코드 1. SELECT p.project_id, ROUND(AVG(e.experience_years), 2) AS average_years FROM Project AS p JOIN Employee AS e ON p.employee_id = e.employee_id GROUP BY p.project_id 2. SELECT p.project_id, ROUND(SUM(e.experience_years)/COUNT(e.experience_years), 2) AS average_years FROM Project AS p JOIN Employee AS e ON p.employee_id = e.employee_id GROUP BY p.project_id 코드 설명 #SELECT #ROUND #AVG #SU..

• format_list_bulleted SQL
• · 2023. 9. 17.
• textsms