Homework: SQL Statements
Instructions
In this homework, you will construct SQL Statements based on a sample data provided in the Excel document located in the homework submission folder located after this page. Here are the steps to follow to complete this short homework:
a. Download the SQL Queries Excel document (Located in the homework submission folder that follows this page).
b. Review the data.
c. After reviewing the examples in our textbook, construct three SQL documents in a Word document to satisfy the following conditions:
d. Write a query in SQL to display the first and last name and salary for those employees who earn below 6000.
e. Write a query in SQL to display the first and last name and salary for all employees who do not earn any commission.
f. Write a query in SQL to display the last name and phone number of employees who were hired before January 1, 2007.
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.