๋ฐ์ํ
https://school.programmers.co.kr/learn/courses/30/lessons/59047
-- ์ฝ๋๋ฅผ ์
๋ ฅํ์ธ์
SELECT ANIMAL_ID, NAME
from ANIMAL_INS
where lower(NAME) like '%el%' and ANIMAL_TYPE = 'DOG'
order by NAME
๋ฐ์ํ
https://school.programmers.co.kr/learn/courses/30/lessons/59047
-- ์ฝ๋๋ฅผ ์
๋ ฅํ์ธ์
SELECT ANIMAL_ID, NAME
from ANIMAL_INS
where lower(NAME) like '%el%' and ANIMAL_TYPE = 'DOG'
order by NAME