1. SELECT TO_CHAR(HIRE_DATE,'MON-YY')
FROM EMPLOYEES E, DEPARTMENTS D, LOCATIONS L WHERE E.DEPARTMENT_ID=D.DEPARTMENT_ID
AND L.CITY = 'Seattle'
GROUP BY TO_CHAR(HIRE_DATE,'MON-YY')
HAVING COUNT(*) > 5;
2. SELECT * FROM JOBS J,EMPLOYEES E
12th June, 2016
American International University Bangladesh
Sub: Application for absences.
For your kind information I am your student of PROGRAMMING LANGUAGE 2 course at section E. I was
absence some of y
Find out the employees who are working in CHICAGO and DALLAS.
List all the Grade2 and Grade 3 emps.
Display all Grade 4,5 Analyst and Manager.
List the names of depts. Where atleast 3 are working in that department.
For designing the above topology you have to meet the following criteria,
Use class B having subnet mask /19
Assign sub-3 to Host LAN and sub-6 to Server LAN
Assign 2nd host IP,28th th host IP, 67 th Host,19th host IP for Host LAN
1) Display all the managers & clerks who work in Accounts and Marketing departments.
2) Display all the salesmen who are not located at DALLAS.
3) Select department name & location of all the employees working for CLARK.
4) Select all the departme