#110. [LeetCode / MySQL] 1907. Count Salary Categories

#110. [LeetCode / MySQL] 1907. Count Salary Categories

문제 입력 코드 (SELECT "Low Salary" AS category, (SELECT COUNT(account_id) FROM Accounts WHERE income = 20000 and income 50000) AS accounts_count) 코드 설명 #SELECT #COUNT #UNION #UNION ALL 문제 출처 LeetCode - The World's Leading Online Programming Learning Platform Level up your ..

  • format_list_bulleted SQL
  • · 2023. 10. 6.
  • textsms
#108. [LeetCode / MySQL] 1164. Product Price at a Given Date

#108. [LeetCode / MySQL] 1164. Product Price at a Given Date

문제 입력 코드 SELECT DISTINCT product_id, 10 AS price FROM Products WHERE product_id NOT IN (SELECT DISTINCT product_id FROM Products WHERE change_date

  • format_list_bulleted SQL
  • · 2023. 10. 4.
  • textsms
#105. [LeetCode / MySQL] 1789. Primary Department for Each Employee

#105. [LeetCode / MySQL] 1789. Primary Department for Each Employee

문제 입력 코드 1. SELECT employee_id, department_id FROM Employee GROUP BY employee_id HAVING COUNT(employee_id) = 1 UNION SELECT employee_id, department_id FROM Employee WHERE primary_flag = 'Y' 2. SELECT DISTINCT employee_id, department_id FROM Employee WHERE employee_id IN ( SELECT employee_id FROM Employee GROUP BY employee_id HAVING COUNT(*) = 1 ) OR primary_flag = 'Y' ORDER BY employee_id; 코드 설명..

  • format_list_bulleted SQL
  • · 2023. 10. 1.
  • textsms
#68. JOIN : 주문량이 많은 아이스크림들 조회하기 | 프로그래머스 | SQL 고득점 Kit

#68. JOIN : 주문량이 많은 아이스크림들 조회하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. JOIN - ON SELECT FH.FLAVOR FROM FIRST_HALF AS FH JOIN JULY AS JUL ON FH.FLAVOR = JUL.FLAVOR GROUP BY FH.FLAVOR ORDER BY SUM(FH.TOTAL_ORDER) + SUM(JUL.TOTAL_ORDER) DESC LIMIT 3; 2. JOIN - USING SELECT FLAVOR FROM FIRST_HALF AS A JOIN JULY AS B USING (FLAVOR) GROUP BY FLAVOR ORDER BY SUM(A.TOTAL_ORDER + B.TOTAL_ORDER) DESC LIMIT 3; → 조인할 두 컬럼의 이름이 같은 경우에는 ON 대신에 USING을 사용할 수 있음 3. SUBQ..

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