Question: Q Level 1 Expected Result 1 N 2 3 Display the country whose Country ID is AR and Region ID 1 record is 2. Columns



Q Level 1 Expected Result 1 N 2 3 Display the country whose Country ID is AR and Region ID 1 record is 2. Columns to show: Country name. Display all countries that contain at least 2 words in the Zero or country name. 2 records Columns to show: Country name. (Both correct depending on script version) Display all locations whose Country ID is either: US, CA, or 7 records MX. Columns to show: City, State/Province, Country ID Order the result by Country ID in alphabetical order. Display all jobs with a Job ID that matches this format: 2 records starts with AD followed by EXACTLY 5 characters. Columns to show: Job ID. Display all departments sorted by their location in 27 records descending order. When multiple departments are located at the same location ID, show their names in alphabetical order. Columns to show: Location ID and Department Name. Level 2 Expected Result 4 5 Q 6 11 records 7 Results unique to each student Display all Employees who were hired in 2008. Columns to show: Employee ID, First and Last name, and the hire date. Order the result by oldest hire date to newest. Display all Employees (if any) whose last name starts with the first letter of your last name. Columns to show: Employee ID, First and Last name. The results should be displayed by first name in alphabetical ordering. Display all Departments without managers whose name contains the word "Sales". Columns to show: Department Name. The results should be displayed by Department name in reverse alphabetical order. 8 00 2 records Level 3 Expected Result Q 9 9 10 Show the job history of anyone whose start date is before the 4 records year 2000. In addition we also want to see any job histories for people with the job id of either MK_REP or SA_REP. Columns to show: Employee ID, Start Date and Job ID The results should be displayed by the oldest start date first. Show all jobs where the max salary remains under 10,000 4 records even with a 25% increase. Columns to show: Job Title, Original Max Salary, New Max Salary after a 25% increase. The results should be displayed based on the lowest new max salary first O+ -Attached PK Hired Jobs HPK job id job_title min_salary max_salary Detailed Employees HPK employee id first_name last_name Manages email phone_number hire_date job_id [FK salary commission_pct manager_id [FK1 department_id [FKI PK Job_History employee id (EK) start date end_date department_id [FKI job_id (FK1 Associate Departments HPK department id department_name manager_ld (FK) location_id [FK1 Heads Located Regions PK region id region_name Locations PK location id street_address postal_code city state_province country_id [FK Grouped to-Resides Countries PK country.id country_name region_id [FKI
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
