Union all


#1

Hi all,

I get an obstacle when manipulating Union all structures on SQL Course.
I just type like this:
select avg(sale_price) from (select id, sale_price from order_items union all select id, sale_price from order_items_historic);
I truly don't know how it's wrong and stuck in.
Pls help me!