Re: ANIDATED SELECT

[Peter Brawley]

select s.storename, x.more_than+3
from storeinfo s
join (
  select orders.store_id, count(*) as more_than_3 
  from order_info 
  join orders on orders.orders_id=orders_info.orders_id 
  where orders_info.num_items > 3 and orders.timeplaced > current timestamp - 1 day 
  group by orders.store_id
) x using(store_id);