SELECT PT_NAME, PT_NO, GEND_CD, AGE, IFNULL(TLNO, 'NONE') AS TLNO
FROM PATIENT
WHERE GEND_CD = 'W' AND AGE <= 12
ORDER BY AGE DESC, PT_NAME
실행결과
2. 최댓값 구하기(정답률74%)
코드 - MAX
SELECT MAX(DATETIME)
FROM ANIMAL_INS
실행결과
3. 과일로 만든 아이스크림 고르기(정답률68%)
코드 - WHERE A AND B, ORDER BY
SELECT F.FLAVOR
FROM FIRST_HALF F, ICECREAM_INFO I
WHERE F.FLAVOR = I.FLAVOR
AND F.TOTAL_ORDER > 3000
AND I.INGREDIENT_TYPE = 'fruit_based'
ORDER BY F.TOTAL_ORDER DESC