[SQL] solvesql Advent of SQL 2024 1일차

# 링크

• solvesql Advent of SQL 2024: https://solvesql.com/collections/advent-of-sql-2024/

https://solvesql.com/collections/advent-of-sql-2024/

 

• 1일차 - 크리스마스 게임 찾기: https://solvesql.com/problems/find-christmas-games/

https://solvesql.com/problems/find-christmas-games/

 

# 풀이

SELECT
  game_id,
  name,
  year
FROM games
WHERE
  name LIKE '%Christmas%'
  OR name LIKE '%Santa%'

• SELECT~: game_id, name, year 컬럼을 선택한다.
• FROM~: games 테이블에서 데이터를 가져온다.
• WHERE~: name 컬럼에 Christmas 또는 Santa가 포함된 데이터를 선택한다.