select count(*) ,t.warehouse , DATE_FORMAT(t.shipped_date, '%Y-%m-%d') shipped_date  from  (		select order_no,warehouse,shipped_date,rowstate from customer_order_tab 	union all 	select order_no,warehouse,shipped_date,rowstate from customer_order_arc_tab ) twhere t.rowstate in ('Delivered','Returned') group by  t.warehouse,DATE_FORMAT(t.shipped_date, '%Y-%m-%d')order by t.shipped_date asc