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