1)
SELECT * FROM PRODUCT
SELECT * FROM ORD

2)
SELECT CUSTID, NAME, ADDRESS, CITY FROM 

CUSTOMER

3) 
SELECT NAME FROM CUSTOMER WHERE 

CREDITLIMIT>6000

4)
SELECT ORDID, CUSTID, SHIPDATE, TOTAL FROM ORD 

WHERE TOTAL>5000
 
5)
SELECT * FROM ORD WHERE TOTAL < 5000 ORDER BY 

TOTAL

6)
SELECT * FROM ITEM ORDER BY ORDID
SELECT * FROM ITEM ORDER BY ITEMID

7)
SELECT ITEMID, PRODID, ACTUALPRICE, QTY, 

ITEMTOT FROM ITEM WHERE ORDID=614 ORDER BY 

ITEMID

8)
SELECT ORDID, ACTUALPRICE, QTY, ITEMTOT FROM 

ITEM WHERE PRODID=100870 AND ITEMTOT >= 200

9)
SELECT ADDRESS FROM CUSTOMER WHERE 

ADDRESS=NULL

10)
SELECT ORDID FROM ORD WHERE 

ORDERDATE=SHIPDATE

11)
SELECT ENAME FROM EMP WHERE MGR IS NULL

12)
SELECT ENAME SPECIAL_EMPLOYEES FROM EMP 

WHERE (JOB='ANALYST' OR JOB='SALESMAN') AND 

COMM IS NULL AND DEPTNO<30

13)
SELECT * FROM DEPT, EMP, CUSTOMER

14)
SELECT ENAME, JOB, SAL FROM EMP WHERE COMM 

IS NOT NULL ORDER BY COMM

15)
SELECT ENAME, JOB, SAL FROM EMP WHERE COMM 

IS NULL
SELECT ENAME, JOB, SAL FROM EMP ORDER BY 

COMM

16)
SELECT ENAME, JOB, HIREDATE, SAL FROM EMP 

ORDER BY HIREDATE, SAL

17)
SELECT ENAME Employee_Name, 12*COMM 

Annual_Commision, 13.5*SAL Annual_Income FROM EMP 

ORDER BY Annual_Income DESC

18)
SELECT ORDID, ORDERDATE, SHIPDATE FROM ORD 

WHERE ORDERDATE BETWEEN '01-JAN-1987' AND 

'30-DEC-1987' ORDER BY ORDERDATE, SHIPDATE