[코드카타] SQL 59 Patients With a Condition

[코드카타] SQL 59 Patients With a Condition

59 Patients With a Condition
https://leetcode.com/problems/patients-with-a-condition/

Write a solution to find the patient_id, patient_name, and conditions of 
the patients who have Type I Diabetes. 
Type I Diabetes always starts with DIAB1 prefix.
Return the result table in any order.

select patient_id, patient_name, conditions
from Patients
where conditions like '% DIAB1%' or conditions like 'DIAB1%'

'%DIAB1%'으로만 할 경우 테스트 통과 안됨.
그 이유는 'ABIDIAB1'와 같은 단어도 포함될 수 있기 때문인데
그래서 conditions like '% DIAB1%' 처럼 한칸 띄워서 DIAB1만 포함된 단어만 설정