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.

Question 9) Using a SET operator, Display all names that are used both as a last name and a first name. Example: Jackson Daniel, Peter Jackson We want to display the name Taylor because it is used in both columns.

Question 10) Display country name and city name. Only show countries without a city and cities without a country.

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]