Database design Objectives: To understand and be able to write simple SQL queries Instruction: Refer to HR schema to answer the questions Include screenshot of your code and output of each question 1. Write SQL query that displays the last name and salary of employees earning more than $12,000. 2. Write SQL query that displays the last name and department number for employee number 176. 3. Write SQL query to display the last name and salary for all employees whose salary is not in the range $5,000 through $12,000. 4. Write SQL query to display the last name, job ID, and hire date for employees with the las

Question

Database design

Objectives:

To understand and be able to write simple SQL queries

Instruction:

Refer to HR schema to answer the questions

Include screenshot of your code and output of each question

1. Write SQL query that displays the last name and salary of employees earning more than $12,000.

2. Write SQL query that displays the last name and department number for employee number 176.

3. Write SQL query to display the last name and salary for all employees whose salary is not in the range $5,000 through $12,000.

4. Write SQL query to display the last name, job ID, and hire date for employees with the last names of Matos and Taylor. Order the query in ascending order by hire date.

5. Display the last name and department ID of all employees in departments 20 or 50 in ascending alphabetical order by name.

6. Write a query that displays the last names of all employees who have both an “a” and an “e” in their last name.

7. Write a query to display the employee number, last name, salary, and salary increased by 11.5% (expressed as a whole number) for each employee. Label the column New Salary.

8. Write a query that displays the last name (with the first letter in uppercase and all the other letters in lowercase) and the length of the last name for all employees whose name starts with the letters “A,” “J,” or “M.” Give each column an appropriate label.

9. Write a query that displays the list of job_id, their average salary is greater than 6500

10. Write a query that displays the number of regions in each country