I'm working on exercise 3/6 in Set Operations - UNION ALL and here's my code:
SELECT avg(sale_price) FROM (
SELECT sale_price FROM order_items
SELECT sale_price FROM order_items_historic);
the answer appears as 62.1063499999998
I'm not getting an error, the system is just preventing me from moving forward. Please advise.