Assignment $1(6\%)$

Instruction:

All the questions are based on HR database.

Submit screenshot for each question that shows the code and the output.

Q$1.$ Write a query in SQL to display first, last name, salary, and department id for those employees who earn below $5000$ and they are working in either department number $50$ or $60(1\%)$

Q$2.$ Display the manager number and the salary of the highest paid employee for that manager. Exclude anyone whose manager is not known. Exclude any groups where the maximum salary is less than $$7,000.$ Sort the output in descending order of salary. $(1\%)$

Q$3.$ Write a query for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label. Use Join clause $(1\mathrm{.}5\%)$

Q$4.$ Write a query that displays the employee number and last name of all employees who work in a department with any employee whose last name contains a $"$s$".$ Use subquery $(1\mathrm{.}5\%)$

Q$5.$ The HR department needs a report that displays the last name, department number, and job ID of all employees who are working in department id $90$ and $100$ and their department located in location ID $1700.$Use subquery $(1\%)$