a. SELECT DNAME, SUM(BASIC) “TOTAL” FROM DEPT, EMP WHERE DEPT.DCODE=EMP.DCODE GROUP BY DNAME;
b. SELECT DNAME FROM DEPT WHERE NOT EXISTS (SELECT * FROM EMP WHERE DEPT.DCODE=EMP.DCODE);
c. SELECT ENAME FROM EMP, DEPT WHERE EMP.DCODE=DEPT.DCODE AND DNAME=’ABC’;
d. SELECT MAX(BASIC) “MAX_BASIC” FROM EMP WHERE DT_JN>01JAN2000;