1 a.	SELECT * FROM PRODUCT

1 b.	SELECT * FROM ORD

2. 	SELECT CUSTID, NAME, ADDRESS, CITY FROM CUSTOMER

4.	SELECT ORDID, CUSTID, SHIPDATE, TOTAL FROM ORD WHERE TOTAL>5000

5.	SELECT * FROM ORD WHERE TOTAL < 5000 ORDER BY TOTAL

8.	SELECT ORDID, ACTUALPRICE, QTY, ITEMTOT FROM ITEM WHERE PRODID=100870 AND ITEMTOT >= 200

10.	SELECT ORDID FROM ORD WHERE ORDERDATE=SHIPDATE

12.	SELECT ENAME SPECIAL_EMPLOYEES FROM EMP WHERE (JOB='ANALYST' OR JOB='SALESMAN') AND COMM IS NULL AND DEPTNO<30

14.	SELECT ENAME, JOB, SAL FROM EMP WHERE COMM IS NOT NULL ORDER BY COMM

17.	SELECT ENAME Employee_Name, 12*COMM Annual_Commision, 13.5*SAL Annual_Income FROM EMP ORDER BY Annual_Income DESC