Question: Question 1 (2.5 points) Use HR database (Sample tables and data are in DatabaseHR.pdf file or you can download it from the course website). Write

 Question 1 (2.5 points) Use HR database (Sample tables and dataare in DatabaseHR.pdf file or you can download it from the coursewebsite). Write a query to show all the names of regions, namesof countries and number of locations in them (including regions/countries with 0

Question 1 (2.5 points) Use HR database (Sample tables and data are in DatabaseHR.pdf file or you can download it from the course website). Write a query to show all the names of regions, names of countries and number of locations in them (including regions/countries with 0 locations). Sort by number of locations starting from the highest number. Question 2 (2.5 points) Use HR database (Sample tables and data are in DatabaseHR.pdf file). Write a query to show all the employees who have salary between 1000 and 2000. Display: last name, first name, employee_id, department name, job title, salary. Sort the output by last name and first name. Database: HR, Tables: Regions Locations Countries Departments Jobs Employees

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!