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