Thrillwill
Question Description
This assignment is about a hospital. It uses SQL 2008 R2 data base. I need help ASAP.
{ Name}
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).
Sub-Categories: Computer Networking
This question has not been answered.
Create a free account to get help with this and any other question!
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors