Question
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,
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
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