[SolveSQL/난이도 1] Advent of SQL 2024(MySQL, SQLite)

크리스마스 게임 찾기

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

 

펭귄 조사하기

SELECT DISTINCT(species), island FROM penguins
ORDER BY island ASC, species ASC

 

지자체별 따릉이 정류소 개수 세기

SELECT local, COUNT(*) as `num_stations` FROM station
GROUP BY local
ORDER BY `num_stations` ASC

 

메리 크리스마스 2024

SELECT 'Merry Christmas!'