* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.

SELECT restaurant_name,

case when price<=5000 then 'price_group1'

when 5000<price<=10000 then 'price_group2'

when 10000<price<=30000 then 'price_group3'

when 30000<price then 'price_group4' end price_group,

case when age < 30 then 'age_group1'

when age between 30 and 39 then 'age_group2'

when age between 40 and 49 then 'age_group3'

else 'age_group4' end age_group

FROM

(SELECT f.restaurant_name,

AVG(price) price,

AVG(age) age

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

group by 1) t

order by 1

저는 쿼리를 이렇게 작성했는데

select restaurant_name,

    case when price <=5000 then 'price_group1'

      when price >5000 and price <=10000 then 'price_group2'

      when price >10000 and price <=30000 then 'price_group3'

      when price >30000 then 'price_group4' end price_group,

    case when age <30 then 'age_group1'

      when age between 30 and 39 then 'age_group2'

      when age between 40 and 49 then 'age_group3'

      else 'age_group4' end age_group

from

(

select a.restaurant_name,

    avg(price) price,

    avg(age) age

from food_orders a inner join customers b on a.customer_id=b.customer_id

group by 1

) t

order by 1

숙제 답안인 것과 결과값이 다르게 나오는데 왜그런건지 알수있을까요??

첫번째 쿼리 출력

2번째 쿼리 출력