Tutorial 5
Structured Query Language (SQL)
You have been hired as a SQL programmer for QQ Corporation. Your first task is to create some reports based on data from the Human Resources (HR) tables.
1. Your first task is to determine the structure of the DEPARTMENTS table and its contents.
2. You need to determine the structure of the EMPLOYEES table.
3. The HR department wants a query to display the last name, job code, hire date, and employee number for each employee, with employee number appearing first. Provide an alias STARTDATE for the HIRE_DATE column.
4. The HR department needs a query to display all unique job codes from the EMPLOYEES table.
5. The HR department wants more descriptive column headings for its report on employees. Name the column headings Emp #, Employee, Job, and Hire Date, respectively.
6. The HR department has requested a report of all employees and their job IDs. Display the last name concatenated with the job code (separated by a comma and space) and name the column Employee and Title.
7. The HR department needs your assistance with creating some queries.
Because of budget issues, the HR department needs a report that displays the last name and salary of employees who earn more than $12,000.
8. Create a report that displays the last name and department number
for employee number 176.
9. The HR department needs to find high-salary and low-salary
employees. Display the last name and salary
for any employee whose salary is not in the range of $5,000 to
$12,000.
10. Display the last name, job, and salary for all employees whose jobs are
either sales representative or stock clerk and whose salaries are not
equal to $2,500, $3,500, or $7,000.