I am also having a problem with this section and keep getting this error:
Error: near line 1: near ";": syntax error Error: near line 14: near "(": syntax error
This is the query I am running:
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'
end as category, round(1.0 * sum(amount_paid)
(select sum(amount_paid) from order_items) * 100.0, 2) as pct
group by 1
order by 2 desc;