[2024/12/23]엑셀보다 쉽고 빠른 SQL 5주차 숙제

음식 타입별, 연령별 주문건수 pivot view 만들기

select cuisine_type,

max(if(age_group=10,order_count,0)) '10대',

max(if(age_group=20,order_count,0)) '20대',

max(if(age_group=30,order_count,0)) '30대',

max(if(age_group=40,order_count,0)) '40대',

max(if(age_group=50,order_count,0)) '50대'

from

(

select fo.cuisine_type,

case when age between 10 and 19 then 10

when age between 20 and 29 then 20

when age between 30 and 39 then 30

when age between 40 and 49 then 40

when age between 50 and 59 then 50

end age_group,

count(1) order_count

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

where c.age between 10 and 59

group by 1, 2

) a

group by 1

#