#109. [LeetCode / MySQL] 1204. Last Person to Fit in the Bus

문제 입력 코드 SELECT q1.person_name FROM Queue AS q1 JOIN Queue AS q2 ON q1.turn >= q2.turn GROUP BY q1.turn HAVING SUM(q2.weight)

• format_list_bulleted SQL
• · 2023. 10. 5.
• textsms

#94. [LeetCode / MySQL] 1193. Monthly Transactions I

문제 입력 코드 1. SELECT DATE_FORMAT(trans_date, '%Y-%m') AS month, country, COUNT(*) AS trans_count, SUM(IF(state='approved', 1, 0)) AS approved_count, SUM(amount) AS trans_total_amount, SUM(IF(state='approved', amount, 0)) AS approved_total_amount FROM Transactions GROUP BY month, country 2. SELECT SUBSTR(trans_date, 1, 7) AS month, country, COUNT(*) AS trans_count, SUM(CASE WHEN state = 'approved' ..

• format_list_bulleted SQL
• · 2023. 9. 20.
• 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

#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

#90. [LeetCode / MySQL] 1251. Average Selling Price

문제 입력 코드 1. SELECT p.product_id, ROUND(SUM(units * price) / SUM(units), 2) AS average_price FROM Prices AS p JOIN UnitsSold AS u ON (p.product_id = u.product_id) AND (u.purchase_date BETWEEN start_date AND end_date) GROUP BY product_id 2. SELECT p.product_id, ROUND(SUM(units * price) / SUM(units), 2) AS average_price FROM Prices AS p INNER JOIN UnitsSold AS u ON (p.product_id = u.product_id) WHE..

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

#70. JOIN : 5월 식품들의 총매출 조회하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 SELECT P.PRODUCT_ID, P.PRODUCT_NAME, SUM(O.AMOUNT * P.PRICE) AS TOTAL_SALES FROM FOOD_PRODUCT AS P JOIN FOOD_ORDER AS O ON P.PRODUCT_ID = O.PRODUCT_ID WHERE O.PRODUCE_DATE BETWEEN '2022-05-01' AND '2022-05-31' GROUP BY O.PRODUCT_ID ORDER BY TOTAL_SALES DESC, O.PRODUCT_ID ASC; 조건1. 생산일자가 2022년 5월인 식품 # 1. BETWEEN WHERE O.PRODUCE_DATE BETWEEN '2022-05-01' AND '2022-05-31' # 2. LIKE WHERE ..

• format_list_bulleted SQL
• · 2023. 8. 29.
• textsms