On this lesson I when following part 1 I got the above error. Upon using the Get Code help it was able to pass, but when I type it how I was shown to format SQL queries it doesn’t work. Why??
SELECT date(ordered_at), ROUND(sum(amount_paid), 2)
ON orders.id = order_items.order.id
WHERE name = ‘kale-smoothie’
GROUP BY 1
ORDER BY 1;