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.