Description
Total points: 13.
For this assignment we will be based on the following database hr:
*Provided by w3resource website
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 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.
-
[1 pt] Provide the SQL code to display the unique department ID from the employees table.
-
[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.
-
[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.
-
[1 pt] Provide the SQL code to display the first_name of all employees who have both “b” and “c” in their first name.
-
[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
-
[1 pt] Provide the SQL code to display the last name of employees whose last names have exactly 5 characters.
-
[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.
-
[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.
-
[1 pt] Provide the SQL code to find the number of jobs in the employees table.
