Description
Instructions
For each question below: read carefully
what is being asked and create an SQL Query which answers the question. Note that it is sometimes possible to
misinterpret the meaning of a question. When in doubt, please clarify with your
instructor before handing in your assignment.
Questions
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)
Make a list of employee ID's beside the country name their department is
located in.
Question 4)
Select all departments whose location is in the Europe Region.
Display the department name, city name, country name, and region name.
Question 5)
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 6)
Using a SET command, show all the countries in region 1 that do not have a
location.
Display only the country_id.
Question 7)
Show all of the department managers who work in Seattle.
Your report should include their manager ID, full name, department name and the
city name.
Question 8)
Show all the Department Names, along with their manager's full names, job
titles and salaries. Note: Department's without a manager will not be shown.
