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