ASKHSH 1, FYLLADIO 10 (SUBQUERIES)
SELECT CUSTOMER.NAME
FROM CUSTOMER
WHERE CUSTOMER.CUSTID IN(
SELECT ORD.CUSTID
FROM ORD
WHERE ORD.ORDID IN(
SELECT ITEM.ORDID
FROM ITEM
WHERE ITEM.QTY>850));
ASKHSH 1 (JOIN)
SELECT DISTINCT CUSTOMER.NAME
FROM CUSTOMER,ORD,ITEM
WHERE CUSTOMER.CUSTID=ORD.CUSTID AND ORD.ORDID=ITEM.ORDID AND ITEM.QTY>850;
SELECT CUSTOMER.NAME
FROM CUSTOMER
WHERE CUSTOMER.CUSTID IN(
SELECT ORD.CUSTID
FROM ORD
WHERE ORDERDATE=(
SELECT MIN(ORD.ORDERDATE)
FROM ORD));
SELECT CUSTOMER.NAME
FROM CUSTOMER,ORD
WHERE CUSTOMER.CUSTID=ORD.CUSTID AND ORDERDATE=(
SELECT MIN(ORDERDATE)
FROM ORD);
SELECT DISTINCT ITEM.ORDID
FROM ITEM,PRICE
WHERE ITEM.PRODID=PRICE.PRODID AND PRICE.ENDDATE='01-DEC-1985';
SELECT DISTINCT CUSTOMER.CITY
FROM CUSTOMER,ORD,ITEM,PRICE
WHERE CUSTOMER.CUSTID=ORD.CUSTID AND ORD.ORDID=ITEM.ORDID AND ITEM.PRODID=PRICE.PRODID AND PRICE.STDPRICE>45;
SELECT DISTINCT PRODUCT.DESCRIP
FROM PRODUCT,ITEM,ORD
WHERE PRODUCT.PRODID=ITEM.PRODID AND ITEM.ORDID=ORD.ORDID AND TOTAL<80;
SELECT ITEM.PRODID,ITEM.ACTUALPRICE,ITEM.QTY
FROM ITEM,ORD,CUSTOMER
WHERE ITEM.ORDID=ORD.ORDID AND ORD.CUSTID=CUSTOMER.CUSTID AND CUSTOMER.NAME LIKE 'WOMENS SPORTS';