Assignment B: SQL Statements Instructions In this assignment, you will – Free Nursing Tutor

Assignment B: SQL Statements Instructions

In this assignment, you will construct SQL Statements based on a sample data provided in the Excel document located in the assignment submission folder located after this page. Here are the steps to follow to complete this short assignment:

  1. Download the SQL Queries Excel document (Located in the assignment submission folder that follows this page).
  2. Review the data.
  3. After reviewing the examples in our textbook, construct three SQL documents in a Word document to satisfy the following conditions:
  4. Write a query in SQL to display the first and last name and salary for those employees who earn below 6000.
  5. Write a query in SQL to display the first and last name and salary for all employees who do not earn any commission.
  6. Write a query in SQL to display the last name and phone number of employees who were hired before January 1, 2007.
  7. Save your work and submit the document to assignment submission folder in this module.

Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

Leave a Reply

Your email address will not be published. Required fields are marked *