주댕이의 공부 기록

# 링크solvesql Advent of SQL 2024: https://solvesql.com/collections/advent-of-sql-2024/ https://solvesql.com/collections/advent-of-sql-2024/ solvesql.com5일차 - 언더스코어(_)가 포함되지 않은 데이터 찾기: https://solvesql.com/problems/data-without-underscore/ https://solvesql.com/problems/data-without-underscore/ solvesql.com # 풀이SELECT DISTINCT page_locationFROM gaWHERE page_location NOT LIKE '%\_%' ESCAPE '\'ORDER ..

# 링크solvesql Advent of SQL 2024: https://solvesql.com/collections/advent-of-sql-2024/ https://solvesql.com/collections/advent-of-sql-2024/ solvesql.com4일차 - 지자체별 따릉이 정류소 개수 세기: https://solvesql.com/problems/count-stations/ https://solvesql.com/problems/count-stations/ solvesql.com # 풀이SELECT     local,     COUNT(*) AS num_stationsFROM stationGROUP BY localORDER BY num_stations ASCSELECT~:local 컬..

# 링크solvesql Advent of SQL 2024: https://solvesql.com/collections/advent-of-sql-2024/ https://solvesql.com/collections/advent-of-sql-2024/ solvesql.com 3일차 - 제목이 모음으로 끝나지 않는 영화: https://solvesql.com/problems/film-ending-with-consonant/ https://solvesql.com/problems/film-ending-with-consonant/ solvesql.com # 풀이SELECT titleFROM filmWHERE rating IN ('R', 'NC-17') AND SUBSTR(title, -1, 1) NOT IN (..

# 링크solvesql Advent of SQL 2024: https://solvesql.com/collections/advent-of-sql-2024/ https://solvesql.com/collections/advent-of-sql-2024/ solvesql.com2일차 - 펭귄 조사하기: https://solvesql.com/problems/inspect-penguins/ https://solvesql.com/problems/inspect-penguins/ solvesql.com# 풀이SELECT DISTINCT  species,  islandFROM penguinsORDER BY  island ASC,  species ASCSELECT DISTINCT~: species, island 컬럼의 고유..

# 링크solvesql Advent of SQL 2024: https://solvesql.com/collections/advent-of-sql-2024/ https://solvesql.com/collections/advent-of-sql-2024/ solvesql.com 1일차 - 크리스마스 게임 찾기: https://solvesql.com/problems/find-christmas-games/ https://solvesql.com/problems/find-christmas-games/ solvesql.com # 풀이SELECT game_id, name, yearFROM gamesWHERE name LIKE '%Christmas%' OR name LIKE '%Santa%'SELECT~: game..