Using the database and tables in Week Two, write SQL queries using 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 the 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 the 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 UNION of the two tables to produce a third table.
· Print out each query and its results along with storing them on a removable disk to use for a presentation in class. Be
prepared to demonstrate your queries in class.
Using the updated database, write the following queries using the SQL GROUP statement:
· Group employees by job classification: Select the employees' last names and group them by EEO-1 Classification.
· Group employees by salary: Select the employees' last names and group them by salary.
· Group employees by salary within their job classification: Select the employees' last names and group them by salary within
their EEO-1 Classification.
· Select the employees' last names and group them by salary within job titles that are grouped into exempt and non-exempt.
· Finally, print out the SQL statements and the results. Be prepared to demonstrate your results in class.
Using the database and tables from Week Three, write queries using the SQL SELECT statement.
Note: Select all of the data from both of your tables before you perform the following.
· Choose an EEO-1 Classification: Increase all employees' salaries that have: the selected EEO-1 classification by 10%.
· Increase all employees' salaries by 5%.
· Choose an employee from the employee table; delete this employee.
· Print out the SQL statements and the data from both tables in order to show how the data was affected. Be prepared to
demonstrate your results in class.
Using the database and tables from Week Three, write SQL statements to:
· Calculate the average salary for all employees.
· Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
· Calculate the maximum salary for all employees.
· Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
· Calculate the minimum salary for all employees.
· Print out the SQL statements and the results. Be prepared to demonstrate your results in class