왜 과제 결과물 예시대로 안나오는지 궁금합니다.. ㅠ

코드를 잘못짠건가요?

작성한 코드 및 에러 메세지

SELECT cuisine_type,

max(if(age between 10 and 19, cnt_order, 0)) "10대",

max(if(age between 20 and 29, cnt_order, 0)) "20대",

max(if(age between 30 and 39, cnt_order, 0)) "30대",

max(if(age between 40 and 49, cnt_order, 0)) "40대",

max(if(age between 50 and 59, cnt_order, 0)) "50대"

from

(

SELECT f.cuisine_type,

c.age,

count(1) cnt_order

from food_orders f inner join customers c on f.customer_id = c.customer_id

group by 1,2

)a

where age between 10 and 59

group by 1