9. Grouping with Case Statements Step 2


#1

https://www.codecademy.com/en/courses/sql-analyzing-business-metrics/lessons/advanced-aggregates/exercises/product-grouping?action=resumeBelow this line, add a link to the EXACT exercise that you are stuck at.


Keeps displaying this error message, 'Group by the category.'



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 amount_paid from order_items) * 100, 2) as pct                    
from order_items 
group by 1
order by 2 desc;


#2

(select sum(amount_paid) from order_items) * 100, 2) as pct

Either I have this wrong, or you do.


#3

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