Grouping with Case Statements - 9.1 SOS


#1

I am not sure what is going on here. I even 'got code' from system but that won't give me the check mark I'm seeking. Error message reads, "Add a Category Column" although Category is already in the statement's out put. Help Please!

select
  case name
    when 'kale-smoothie'    then 'smoothie'
    when 'banana-smoothie'  then 'smoothie'
    when 'orange-juice'     then 'drink'
    when 'soda'             then 'drink'
    when 'blt'              then 'sandwich'
    when 'grilled-cheese'   then 'sandwich'
    when 'tikka-masala'     then 'dinner'
    when 'chicken-parm'     then 'dinner'
    else 'other'
  end as category, round(1.0 * sum(amount_paid) /
    (select sum(amount_paid) from order_items) * 100, 2) as pct
from order_items
group by 1
order by 2 desc;

#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.