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 – take a screen shot of your “successful” implementation of your code and submit as an attachment. Update the data dictionary if necessary and submit as an attachment. Project 2: Save all of your code in Notepad as a *.txt file SQL Reports Use the database and tables from Project 1 to write SQL queries using the SQL SELECT statement. Note. Select all data from both tables before you perform the following: Increase all employees' salaries with the selected EEO-1 classification by 10%. Increase all employees' salaries by 5%. Choose an employee from the Employee table and delete that employee. Save the SQL statements and screen shots of successful implementation of both tables in a txt file to show how data was affected. Submit as attachments. Use the database and tables from Project 1 to write SQL statements that do the following: 1. Calculate the average salary for all employees. 2. Calculate the maximum salaries for exempt and non-exempt employees. 3. Calculate the maximum salary for all employees. 4. Calculate the minimum salaries for exempt and non-exempt employees. 5. Calculate the minimum salary for all employees. 6. Update Data Dictionary if necessary. Screen Shot – take screen shots of your successful implementation of your code and submit as attachments. Save your SQL in a txt file in Notepad.