1. SELECT * FROM hr.employees;
2.  
3. SELECT first_Name FROM hr.employees;
4.  
5. SELECT * FROM hr.employees
6. WHERE last_name = 'King';
7.  
8. SELECT COUNT(*) FROM hr.employees;
9.  
10. SELECT SUM(salary) FROM hr.employees;
11.  
12. SELECT MAX(salary) FROM hr.employees;
13. SELECT MIN(salary) FROM hr.employees;
14. SELECT avg(salary) FROM hr.employees;
15.  
16. SELECT * FROM hr.employees
17. WHERE salary > 6000;
18.  
19.  
20. SELECT * FROM hr.employees
21. WHERE DEPARTMENT_ID = 60
22. AND salary>6000;
23.  
24. SELECT first_name, last_name, salary FROM hr.employees
25. WHERE DEPARTMENT_ID = 60
26. AND salary>6000;
27.  
28. SELECT * FROM hr.employees
29. WHERE salary > (SELECT avg(salary) FROM hr.employees);
30.  
31. SELECT * FROM hr.employees
32. WHERE first_name LIKE 'S%';
33.  
34. SELECT * FROM hr.employees
35. WHERE last_name LIKE '%n';
36.  
37. SELECT * FROM hr.employees
38. WHERE last_name LIKE '%n%';
39.  
40. SELECT COUNT(DISTINCT(EMPLOYEE_ID)) FROM hr.employees;
41.  
42. SELECT DISTINCT(salary) FROM hr.employees;
43.  
44. SELECT * FROM hr.employees
45.     WHERE COMMISSION_PCT IS NULL;
46.  
47. SELECT * FROM hr.employees
48.     WHERE COMMISSION_PCT IS NOT NULL
49.     AND manager_id != 100;
50.  
51. SELECT * FROM hr.employees
52. WHERE salary = 9000
53. OR salary = 7500;
54.  
55. SELECT * FROM hr.employees
56. WHERE HIRE_DATE > '09-DEC-06';
57.