Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

No CONCAT please. thank you Question 1) Show all employees whose current job has a max salary of at least 9000. Display the employee id,

image text in transcribed

No CONCAT please. thank you

Question 1) Show all employees whose current job has a max salary of at least 9000. Display the employee id, full name, job title and max salary. Sort the results by the largest max salary first.

Question 2) Make a query which shows us the job histories of the employees with the following employee id's: 176, 200, 101, and 102. Show the full name, job title, job ID, the date the job ended, and the maximum salary of that job. Order the results by Last Name in descending order and then order by End Date from oldest date to newest.

Question 3) Show all location ids and City names of all locations that do not have a department and are not in the country of Mexico.

Question 4) Using a SET command, show all the countries in region 1 that do not have a location. Display only the country_id.

Employees ot OH PK employee id -Attached first_name Jobs last_name OH PK job id Job_History email PK Manages employee id [FK) Hired job_title Detailed phone_number min_salary PK start date hire_date max_salary end_date job_id [FK] department_id [FK] salary job_id [FK] commission_pct manager_id [FK] Departments oh PK department id Ho -Associated department_id [FK] department_name Locations manager_id [FK] Heads PK location id location_id [FK] po-Located street_address Regions postal_code PK region id Ito -Grouped Countries city PK country_id Ho-Resides region_name state_province country_name country_id [FK) region_id [FK]

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_2

Step: 3

blur-text-image_3

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

Computer Aided Database Design

Authors: Antonio Albano, Valeria De Antonellis, A. Di Leva

1st Edition

0444877355, 978-0444877352

More Books

Students also viewed these Databases questions

Question

=+from: a) a MNEs perspective? and b) the HRM managers perspective?

Answered: 1 week ago