POS 410 Week 3 Individual Assignment Data Changes and SQL Statements

POS 410 Week 3 Individual Assignment Data Changes and SQL Statements | University Of Phoenix 

POS 410 Week 3 Individual Assignment  Data Changes and SQL Statements
 
Use the database and tables from last week's assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.
 
Use the database and tables from last week's assignment to write SQL queries using Between, Like, and Union. Write an SQL query that does the following:
 
Joins two tables in the database and uses BETWEEN to restrict record selection. Use salary to restrict data.
Joins two tables in the database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
Joins two tables in the database and uses IN to restrict record selection. Use specific city names to restrict data.
Write a SQL query that joins two tables in the database and uses LIKE to restrict record selection. (Use zip codes to restrict data.)
Using the HAVING command, how many positions have more than 3 employees? (e.g. Cashiers, 4).
 
Use the updated database to write the following queries, using the SQL GROUP statement:
Select employees' last names and group them by EEO-1 classification.
Select employees' last names and group them by salary.
Select employees' last names and group them by salary in job titles, grouped into exempt and non-exempt.
Human Resources has requested a listing of employees. They want the listing to show the first initial of the employee's last name. In addition, they want the report in the following sort order: exempt/non-exempt status, the first letter of their last name, last name, first name and salary. For example: Exempt, S, Smith, Bob, $50,000
.