Description
Objective: Create basic SELECT statements including WHERE / ORDER BY clauses
Problem 1:
Create a query showing employees (employee_id, first_name, last_name) that are sales people (= having a commission
percentage). Order the resulting set by last_name and first_name in ascending order:
Problem 2:
Create a query showing all employees(employee_id, first_name, last_name, salary) that earn more than $10,000 in
descending order by salary:
Problem 3:
Create a query showing all employees(employee_id, first_name, last_name, hire_date) that were hired in 1996 in
descending order by hire date:
Problem 4:
Create a query showing all employees(employee_id, first_name, last_name, salary) whose salary is in the range of $5000
and $10,000 in ascending order by salary:
Problem 5:
Show all employees (employee_id, first_name, last_name) whose last name contains a blank space:
Problem 6:
Display all employees(employee_id, first_name, last_name) whose first name contains the letter a in the 3rd position
ordered by last_name in descending order:
Problem 7:
Part 1: Show the country_id values in ascending order from table locations for country_id values of IT, UK, and US.
Part 2: Now show only the unique country_id values in ascending order based on the query in part 1. Explain the
difference in the number of output records.
Part 3: Finally, display the unique values of country_id and state_province based on the query in part 1. Again, explain
the difference compared to only unique country_id values..