Module 4: assignment b: sql statements instructions

/in /by

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.