Scribd
Upload
2 views1 page

Homework1 SQL

The document outlines a series of homework tasks related to querying employee and location data from a database. Tasks include displaying employee details based on salary, job title, hire date, and commission percentage, as well as retrieving unique city names and filtering employees by specific criteria. The queries focus on various conditions such as salary thresholds, job roles, and name patterns.

Uploaded by

jackiefan475
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views1 page

Homework1 SQL

The document outlines a series of homework tasks related to querying employee and location data from a database. Tasks include displaying employee details based on salary, job title, hire date, and commission percentage, as well as retrieving unique city names and filtering employees by specific criteria. The queries focus on various conditions such as salary thresholds, job roles, and name patterns.

Uploaded by

jackiefan475
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Homework

1. Display first name and last name as full name, salary, commission pct, and
hire date for employees with salary less than 10000.
2. Display city names (without repeated names) in ascending order from
locations table.
3. Display the first name, hire date and job ID of the employees who is either
IT Programmer or Sales Manager, and hired between 2002 and 2005.
4. Display details from jobs table in the descending order of the job title.
5. Display details of the employees where commission percentage is null and
salary in the range 5000 to 10000 and department id is 30.
6. Display employees who joined after 1st January 2008.
7. Display details of employees with ID 150, 160 or 170.
8. Display employees where the first name or last name starts with S.
9. Display first and last name for employees where last name contains
character ‘b’ after 3rd position.

You might also like