Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Oracle9i Database Administration

Authors: Sam R. Alapati

1st Edition

1590590228, 978-1590590225

More Books

Students also viewed these Databases questions