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 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
Get step-by-step solutions from verified subject matter experts
