[LeetCode] 619. Biggest Single Number [문제] [MySQL]WITH num_cnt AS ( SELECT * , COUNT(*) OVER (PARTITION BY num) AS cnt FROM MyNumbers)SELECT MAX(num) AS numFROM num_cntWHERE cnt = 1 SQL/LeetCode 2025.02.18
[LeetCode] 610. Triangle Judgement [문제] [MySQL]SELECT * , CASE WHEN (x+y>z AND y+z>x AND z+x>y) THEN 'Yes' ELSE 'No' END AS triangleFROM Triangle SQL/LeetCode 2025.02.18
[LeetCode] 608. Tree Node [문제] [MySQL]WITH node AS ( SELECT t1.* , t2.id AS c_id FROM Tree AS t1 LEFT JOIN Tree AS t2 ON t1.id = t2.p_id)SELECT DISTINCT id , CASE WHEN p_id IS NULL THEN 'Root' WHEN c_id IS NULL THEN 'Leaf' ELSE 'Inner' END AS typeFROM node SQL/LeetCode 2025.02.18
[LeetCode] 607. Sales Person [문제] [MySQL]WITH company_red AS ( SELECT s.name FROM Orders AS o LEFT JOIN SalesPerson AS s ON o.sales_id = s.sales_id LEFT JOIN Company AS c ON o.com_id = c.com_id WHERE c.name = 'RED')SELECT nameFROM SalesPersonWHERE name NOT IN (SELECT name FROM company_red) SQL/LeetCode 2025.02.18
[LeetCode] 602. Friend Requests II: Who Has the Most Friends [문제] [MySQL]WITH Activity AS ( SELECT requester_id AS id FROM RequestAccepted UNION ALL SELECT accepter_id AS id FROM RequestAccepted)SELECT id , COUNT(*) AS numFROM ActivityGROUP BY idORDER BY num DESCLIMIT 1 SQL/LeetCode 2025.02.18
[LeetCode] 601. Human Traffic of Stadium [문제] [MySQL]WITH three_rows AS ( SELECT * , COUNT(*) OVER (ORDER BY visit_date ASC ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS cnt1 , MIN(people) OVER (ORDER BY visit_date ASC ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS min1 , COUNT(*) OVER (ORDER BY visit_date ASC ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS cnt2 , MIN(people) OVER (ORDER BY visit_date ASC ROWS.. SQL/LeetCode 2025.02.18
[LeetCode] 596. Classes More Than 5 Students [문제] [MySQL]WITH student_cnt AS ( SELECT class , COUNT(DISTINCT student) AS cnt FROM Courses GROUP BY class)SELECT classFROM student_cntWHERE cnt >= 5 SQL/LeetCode 2025.02.18
[LeetCode] 595. Big Countries [문제] [MySQL]SELECT name , population , areaFROM WorldWHERE area >= 3000000 OR population >= 25000000 SQL/LeetCode 2025.02.18
[LeetCode] 586. Customer Placing the Largest Number of Orders [문제] [MySQL]WITH order_cnt AS ( SELECT customer_number , COUNT(DISTINCT order_number) AS cnt FROM Orders GROUP BY customer_number) SELECT customer_numberFROM order_cntWHERE cnt = (SELECT MAX(cnt) FROM order_cnt) SQL/LeetCode 2025.02.18
[LeetCode] 585. Investments in 2016 [문제] [MySQL]SELECT ROUND(SUM(tiv_2016), 2) AS tiv_2016FROM InsuranceWHERE tiv_2015 IN (SELECT tiv_2015 FROM Insurance GROUP BY tiv_2015 HAVING COUNT(*) > 1) AND (lat, lon) IN (SELECT DISTINCT lat, lon FROM Insurance GROUP BY lat, lon HAVING COUNT(*) = 1) SQL/LeetCode 2025.02.18
