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