ITCO333 – Unit 4
{date}
Note: Unit 2’s assignment provided the specifications for the EMPLOYEES and DEPARTMENTS tables.
Update the Employees table and give all employees making less than $10 per hour a 5% increase.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
List all records/fields in the EMPLOYEES table in order of the employee’s last name.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
List all records/fields in the EMPLOYEES table in order of the department name.
Note: Department name is not in the Employees table.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
List employee names, hourly pay rate and department name for employees making between (and including) $10 and $30 per hour.
Note: Department name is not in the Employees table.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
What is the total organization payroll assuming each employee works 40 hours per week?
Note: Do not permanently change the data in your tables to arrive at the answer.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
EXAMPLE: WHERE clause using comparison operators
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
EXAMPLE: ORDER BY clause
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
EXAMPLE: JOINS
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
EXAMPLE: Aggregation
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).
Page 2 of 9
jun184
unit_4_ip_template.docx
0
