Assignment Instructions/ Description
Questions
1. Use the “hrdb_part2.sqi" (under Experiments tab in D2L) to create more tables in the“hrdb” database that you created in your Assignment 3. After you created the tables, use“show tables;”, and attach the screenshot to your solution.
2. Answer the following questions with SQL statements, and attach screenshots. (You needto provide SQL statements and screenshots of the results / part of the results) — useemployees table.
1. Write a query to find the name (first_name, last_name) and the salary of the employeeswho have a higher salary than the employee whose last_name="Bul.
2. Write a query to find the name (first_name, last_name) of all employees who works inthe IT department
3. Write a query to find the name (first_name, last_name) of the employees who have amanager and worked in a USA based department.
4. Write a query to find the name (first_name, last_name), and salary of the employeeswhose salary is greater than the average salary.
5. Write a query to find the name (first_name, last_name), and salary of the employeeswhose salary is equal to the minimum salary for their job grade.
1
Post a Comment