Fri 19 Jun, 2020 09:57 am - select suplierid
from product
where exist
(select productid
from orderitem
where unitprice>100$
i don't whether it is correct or not.
(view)
Fri 19 Jun, 2020 09:50 am - select prod_name from product where productid in
(select prod_id from item where quantity > 100);
this is what i've done. Can you guys correct me if I'm wrong (view)
Fri 19 Jun, 2020 09:42 am - You are required to find suppliers with products over $100 using Type 2 Nested query.
PRODUCT(PROD_ID,PROD_NAME,SUPPLIER_ID,UNITPRICE,PACKAGE,ISDISCONTINUED)
ORDER... (view)
Fri 19 Jun, 2020 09:39 am - Based on the tables below:
PRODUCT(*PROD_ID*,PROD_NAME,SUPPLIER_ID,UNITPRICE,PACKAGE,ISDISCONTINUED)
ORDER ITEM(*ID*,ORDERID,PRODUCTID,UNITPRICE,QUANTITY)
You are required to list products... (view)
Fri 29 May, 2020 11:15 am - Okay for now I understand that but how can I differentiate whether it is left, right or full outer join? and can you show me the answer to your example for my reference. (view)
Fri 29 May, 2020 11:09 am - I have friends, I always help them whenever they want me but when I need 'em, they're gone. I'm pissed but when they ask for help again I will help them out. What should I do? Share... (view)
Fri 29 May, 2020 10:50 am - Can you explain more? I don't understand. Well this is suppose to be my assignment for my online learning and I have to learn it by myself so I don't understand this topic very much and... (view)