Questions: 1. In what department does Scott work? 2. Who start working from 04-Apr-1981 till 04-Sep-1981 3. How many people start work in each year 4. Who are the workers that start job in the last year? 5. How many workers with position “QA Engineer” work in each department 6. Show departments where there are not less than 4 workers 7. Show the workers who are not managers 8. What is Braun’s position 9. Show all data for the worker with the biggest ID • Using “NOT EXIST” • Using “ALL” • Using “MAX” 10. Show Departments where there are more than 2 QA Engineer. Questions are written in Hebrew and related to Oracle BD Answers: 1) SELECT DEPARTMENTS.DEP_NAME FROM EMPLOYEES INNER JOIN DEPARTMENTS ON EMPLOYEES.DEP_ID = DEPARTMENTS.DEP_ID WHERE (EMPLOYEES.LASTNAME = 'Scott') 2) SELECT LASTNAME FROM EMPLOYEES WHERE (STARTDATE BETWEEN TO_DATE('4/4/1981', 'DD/MM/YYYY') AND TO_DATE('9/4/1981', 'DD/MM/YYYY')) 3) SELECT COUNT(ID) AS EMPLOYEESSTARTWORKING, TO_CHAR(STARTDATE, 'YYYY') AS YEARW FROM EMPLOYEES GROUP BY TO_CHAR(STARTDATE, 'YYYY') 4) SELECT LASTNAME FROM EMPLOYEES WHERE (TO_CHAR(STARTDATE, 'YYYY') = TO_CHAR(SYSDATE, 'YYYY')) 6) SELECT DEPARTMENTS.DEP_NAME FROM EMPLOYEES INNER JOIN DEPARTMENTS ON EMPLOYEES.DEP_ID = DEPARTMENTS.DEP_ID GROUP BY DEPARTMENTS.DEP_NAME HAVING (COUNT(EMPLOYEES.ID) >= 4) 7) SELECT LASTNAME FROM EMPLOYEES WHERE (POSITION <> 'Manager') SELECT POSITION FROM EMPLOYEES WHERE (LASTNAME = 'Braun') 9.1) SELECT ID, LASTNAME, POSITION, STARTDATE, DEP_ID FROM EMPLOYEES WHERE (ID IN (SELECT MAX(ID) AS ID FROM EMPLOYEES EMPLOYEES_1)) 9.2) SELECT A.*, B.* FROM EMPLOYEES A, DEPARTMENTS B WHERE A.DEP_ID =B.DEP_ID AND A.ID = ALL (SELECT MAX(ID) FROM EMPLOYEES C) 9.3) SELECT A.* , B.* FROM EMPLOYEES A, DEPARTMENTS B WHERE A.DEP_ID = B.DEP_ID AND A.ID = (SELECT MAX(C.ID) FROM EMPLOYEES C) 10) SELECT DEPARTMENTS.DEP_NAME FROM EMPLOYEES INNER JOIN DEPARTMENTS ON EMPLOYEES.DEP_ID = DEPARTMENTS.DEP_ID GROUP BY DEPARTMENTS.DEP_NAME, EMPLOYEES.POSITION HAVING (COUNT(EMPLOYEES.ID) > 2) AND (EMPLOYEES.POSITION = 'QA E