[SQL문제풀기 - Advent of SQL 2025 🎅] 사랑에 대한 영화 찾기

silver

Nov 30, 2025

[SQL문제풀기 - Advent of SQL 2025 🎅] 사랑에 대한 영화 찾기

Contents

문제 MySQL SQLite PostgreSQL

문제

solvesql.com

https://solvesql.com/problems/movies-about-love/

MySQL

내가 작성한 정답

: 이전에 Leetcode에서 풀었던 mysql문제에서는 like를 사용해도 대소문자를 따로 구분하기 위해 binary를 사용해야했으나 여기서는 그냥 구분이 되었다. 물론 binary를 사용해도 되었다


select title, year, rotten_tomatoes
from movies
where title like '%Love%'
    or title like '%love%'
order by 3 desc, 2 desc;

select title, year, rotten_tomatoes
from movies
where binary title like '%Love%'
    or binary title like '%love%'
order by 3 desc, 2 desc;

SQLite

내가 작성한 정답


select title, year, rotten_tomatoes
from movies
where title like '%Love%'
    or title like '%love%'
order by 3 desc, 2 desc;

PostgreSQL

내가 작성한 정답


select title, year, rotten_tomatoes
from movies
where title like '%Love%'
    or title like '%love%'
order by 3 desc, 2 desc;

SQL문제풀기

[SQL문제풀기 - Advent of SQL 2025 🎅] 사랑에 대한 영화 찾기

silver

Nov 30, 2025

Contents

문제 MySQL SQLite PostgreSQL

문제

solvesql.com

https://solvesql.com/problems/movies-about-love/

MySQL

내가 작성한 정답


select title, year, rotten_tomatoes
from movies
where title like '%Love%'
    or title like '%love%'
order by 3 desc, 2 desc;

select title, year, rotten_tomatoes
from movies
where binary title like '%Love%'
    or binary title like '%love%'
order by 3 desc, 2 desc;

SQLite

내가 작성한 정답


select title, year, rotten_tomatoes
from movies
where title like '%Love%'
    or title like '%love%'
order by 3 desc, 2 desc;

PostgreSQL

내가 작성한 정답


select title, year, rotten_tomatoes
from movies
where title like '%Love%'
    or title like '%love%'
order by 3 desc, 2 desc;