어제보다 나은 나 LET'S GO

https://solvesql.com/problems/multiple-medalist/ https://solvesql.com/problems/multiple-medalist/ solvesql.com[풀이]SELECT a.nameFROM records r LEFT JOIN athletes a ON r.athlete_id = a.idLEFT JOIN teams t ON r.team_id = t.idLEFT JOIN games g ON r.game_id = g.idWHERE g.year >= 2000 AND r.medal IS NOT NULLGROUP BY a.idHAVING COUNT(DISTINCT t.id) >= 2ORDER BY a.name*주의: group by를 unique key값인 id로 하지 ..

https://solvesql.com/problems/redefine-session/ https://solvesql.com/problems/redefine-session/ solvesql.com [풀이]SELECT user_pseudo_id, MIN(event_timestamp_kst) AS session_start, MAX(event_timestamp_kst) AS session_endFROM ( SELECT step2.*, CASE WHEN last_diff IS NULL THEN id WHEN last_diff >= 3600 THEN id ELSE LAG(id, 1) OVER (PARTITIO..

https://solvesql.com/problems/revenue-pct-per-category/ https://solvesql.com/problems/revenue-pct-per-category/ solvesql.com  [풀이]SELECT category, sub_category,ROUND(SUM(sales),2) AS sales_sub_category,ROUND(SUM(SUM(sales)) OVER (PARTITION BY category), 2) AS sales_category, ROUND(SUM(SUM(sales)) OVER (), 2) AS sales_total, ROUND((SUM(sales) / SUM(SUM(sales)) OVER (PARTITION BY category)) * 100,..