[SQL문제풀기] 제목이 모음으로 끝나지 않는 영화

문제

solvesql.com

https://solvesql.com/problems/film-ending-with-consonant/

SQLite

내가 작성한 정답

// not like
select title
from film
where rating in ('R','NC-17')
    and (title not like '%A' and title not like '%E' and title not like '%I'
          and title not like '%O' and title not like '%U');
          
// substr
 select title
from film
where rating in ('R','NC-17')
  and substr(title,-1) not in ('A','E','I','O','U');