Re: ANIDATED SELECT
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 ON x.store_id = s.store_id
Edited 1 time(s). Last edit at 10/24/2017 08:34AM by Peter Brawley.
Subject
Written By
Posted
Re: ANIDATED SELECT
October 24, 2017 08:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.