Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started