L07-Employee 1 L07-Employee Step 1: Creating the Employee Table Write a CREATE TABLE statement with the following columns: employee_id : Integer (primary key) first_name : String last_name : String job_id : String salary : Decimal manager_id : Integer (foreign key) department_id : Integer (foreign key) Step 1.2: import the employee.csv file. Step 2: Finding High-Paid Employee Compared to Ahmad 1. Use a SELECT statement with first_name and salary . 2. Add a WHERE clause with two subqueries: Inner subquery: Find the employee's salary with the last name Kumar: (SELECT salary FROM employees WHERE last_name = 'Ahmad') . Outer subquery: Filter for employees with higher salary: salary > (SELECT salary FROM (... inner subquery ...)) . Step 3: Finding Employees with Salaries Above Average 1. Use a SELECT statement with employee_id and last_name . 2. Find the average salary using a subquery: AVG(salary) AS average_salary from the employees table. L07-Employee 2 3. Add a WHERE clause to filter for employees with salaries higher than the average: salary > (SELECT average_salary ...) . Step 4: Finding High-Paid Employees Excluding Shipping Clerks 1. Use a SELECT statement with employee_id , first_name , and salary . 2. Add a WHERE clause to filter for salaries higher than all shipping clerks: salary > (SELECT MAX(salary) FROM employees WHERE job_id = 'HP122') . 3. Sort the results by salary in ascending order using ORDER BY salary ASC . Step 5: Finding Top-Paid Employees 1. Use a SELECT statement with first_name , employee_id , and salary . 2. Add a LIMIT clause to only retrieve the top three records: LIMIT 3 . 3. Use ORDER BY salary DESC to sort by salary in descending order, showing the highestpaid first.