1. --1
2. SELECT e.first_name , e.last_name, j.JOB_TITLE
3. FROM EMPLOYEES e JOIN jobs j USING(job_id);
4.  
5. --2
6. SELECT  DISTINCT COUNT(e.first_name)
7. FROM EMPLOYEES e JOIN jobs j USING(job_id)
8. WHERE j.JOB_TITLE = 'Sales Manager';
9.  
10. --3
11. SELECT e.first_name, e.last_name, TO_CHAR(e.hire_date,'yyyy/month')
12. FROM EMPLOYEES e;
13.  
14. --4
15. --5
16. --6
17. --7
18. SELECT COUNT(e.EMPLOYEE_ID ), d.DEPARTMENT_NAME
19. FROM EMPLOYEES e JOIN DEPARTMENTS d ON e.DEPARTMENT_ID = d.DEPARTMENT_ID
20. WHERE TO_CHAR(e.HIRE_DATE,'yyyy')IN ('2005','2006')
21. GROUP BY d.DEPARTMENT_NAME
22. ORDER BY 2;
23.  
24. --8
25. --9
26. SELECT d.DEPARTMENT_NAME, e.FIRST_NAME, e.LAST_NAME
27. FROM DEPARTMENTS d JOIN EMPLOYEES e ON d.DEPARTMENT_ID = e.DEPARTMENT_ID
28. WHERE e.JOB_ID NOT LIKE '%IT%';
29.  
30. --10
31. SELECT COUNT(e.EMPLOYEE_ID), j.JOB_TITLE
32. FROM JOBS j JOIN EMPLOYEES e ON j.JOB_ID = e.JOB_ID
33. WHERE TO_CHAR(e.HIRE_DATE,'MM') IN (1,2,3)
34. GROUP BY j.JOB_TITLE;
35.  
36. --11
37. SELECT d.DEPARTMENT_NAME, l.CITY, c.COUNTRY_NAME
38. FROM DEPARTMENT d JOIN LOCATIONS l ON d.LOCATION_ID = l.LOCATION_ID
39. JOIN HR.COUNTRIES  c ON  c.COUNTRY_ID=l.COUNTRY_ID;
40.  
41.  
42.  
43.