1.COUNT THE NO OF EMPLOYEES IN DEPARTMENT NAME SALES.
2.LIST ALL THE EMPLOYEE’S NAME WORKING NOT IN SEATTLE(IT IS A CITY NAME IN LOCATION TABLE).
3.GIVE THE GRADE TO ALL THE EMPLOYEES IN EMP TABLE ,THE
GRADES DEPENTS UPON THE MINSAL AND MAXSAL IN JOBS TABLE.
4.LIST THE EMPLOYEES WORKING IN THE SAME DEPARTMENT AS THAT
OF EMPLOYEES 7900.
5.FIND THE MANAGER NAME FOR ALL THE EMPLOYEES.
6.SHOW ALL THE RECORD
FROM EMP EVEN THERE IS NO DEPTNO CORRESPOND TO EMP.
No comments:
Post a Comment