Grouping with Case Statements - Step 2


#1

Can’t complete stage 2.
This is the code.
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;



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

i too have the same issue. the interactive screen is not working!


#3

Same here, browser suspends when trying to execute this code.


#4

I came up with the exact same code and system tells me it’s the wrong answer. Bug or wrong code?


#5

Having the same issue


#6

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