#106. [LeetCode / MySQL] 610. Triangle Judgement

문제 입력 코드 1. SELECT x, y, z, (CASE WHEN x+y Y, "Yes", "No") AS Triangle FROM Triangle 코드 설명 #SELECT #CASE WHEN #ELSE #IF 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com

• format_list_bulleted SQL
• · 2023. 10. 2.
• 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

#88. [LeetCode / MySQL] 1934. Confirmation Rate

문제 입력 코드 1. SELECT s.user_id, ROUND(AVG(IF(c.action="confirmed",1,0)),2) AS confirmation_rate FROM Signups AS s LEFT JOIN Confirmations AS c USING(user_id) GROUP BY user_id 2. WINDOW - PARTITION BY SELECT DISTINCT s.user_id, ROUND(SUM( CASE WHEN c.action = 'confirmed' THEN 1 ELSE 0 END ) OVER (PARTITION BY user_id) / COUNT(*) OVER (PARTITION BY user_id), 2) AS confirmation_rate FROM Signups AS s..

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

#45. STRING, DATE : 중성화 여부 파악하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. CASE SELECT ANIMAL_ID, NAME, (CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' THEN 'O' WHEN SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O' ELSE 'X' END) AS '중성화' FROM ANIMAL_INS ORDER BY ANIMAL_ID; 2. IF SELECT ANIMAL_ID, NAME, IF(SEX_UPON_INTAKE LIKE '%NEUTERED%' OR SEX_UPON_INTAKE LIKE '%SPAYED%','O','X') AS '중성화' FROM ANIMAL_INS ORDER BY ANIMAL_ID ASC; 3. 정규식 SELECT ANIMAL_ID, NAME, IF(SEX_..

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

#09. SELECT : 12세 이하인 여자 환자 목록 출력하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 SELECT PT_NAME, PT_NO, GEND_CD, AGE, IFNULL(TLNO, "NONE") AS TLNO FROM PATIENT WHERE (AGE

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