12/4-2 where clause

Can anybody pls help without where clause syntax working

thanks in advance
<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>


select DATE(ordered_at), round(sum(amount_paid), 2)
from orders
join order_items
on orders.id = order_items.order_id

where name = ‘kale-smoothie’

group by 1
order by 1

<do not remove the three backticks above>

missing ; lol

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