Total points: 13.
For this assignment we will be based on the following database hr:
It's good practice to make SQL keywords uppercase to distinguish them from other parts of your query. Please do this to make it easier for the grader. Also remember to include a semicolon at the end of your query. This tells SQL where the end of your query is!
1. [1 pt] Provide the SQL code to display the names (first_name, last_name separately) using alias names FirstName and LastName, respectively, from the employees table.
2. [1 pt] Provide the SQL code to display the unique department ID from the employees table.
3. [1.5 pts] Provide the SQL code to display the first and last names, salary and PF of all the employees (PF is calculated as 15% of salary) of all employees according to their first name in descending order.
3. [1.5 pts] Provide the SQL code to display the name (first_name, last_name) and salary for all employees whose salary is not in the range $10,000 through $15,000 and are in department 30 or 100.
4. [1 pt] Provide the SQL code to display the first_name of all employees who have both “b” and “c” in their first name.
5. [2 pts] Provide the SQL code display the last name, job, and salary for all employees whose job is that of a IT Programmer (IT_PROG) or a Shipping Clerk (SH_CLERK), and whose salary is not equal to $4,500, $10,000, or $15,000
6. [1 pt] Provide the SQL code to display the last name of employees whose last names have exactly 5 characters.
7. [1.5 pts] Provide the SQL code to display the name (first_name, last_name), job, department ID, and department name of all the employees who work in London.
8. [1.5 pts] Provide the SQL code to display the employee ID, job id, job title, and minimum salary of all employee ids from the job_history even if they have a null job id.
9. [1 pt] Provide the SQL code to find the number of jobs in the employees table.
