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 text2. 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 text2. Include a screen shot of SQL3. 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 SQL3. 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 SQL3. 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 SQL3. Include a screen shot of the results (there must be some results). EXAMPLE: AGGREGATION 1. Paste SQL as text2. Include a screen shot of SQL3. Include a screen shot of the results (there must be some results). Sub-Categories: Computer Networking
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.