Project #1
Save all of your code in Notepad as a *.txt file and attach it when you submit the project. Take screen shots of all successful implementation of each set of SQL.
Data Changes and SQL Statements
Resource: Table Queries assignment
Use the database and tables that are attached to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the store. Check results by selecting all columns from both tables.
Between, Like, and Union:
Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.
Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.
Write a SQL query that uses the UNION of the two tables to produce a third table.
Save each query in a txt file and take a screen shot of its results and submit them as an attachment.
Group:
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 their EEO-1 classification.
Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.
Save all the SQL statements in a txt file and submit as an attachment.
Screen Shot
