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';