Reference no: EM13930312
Using the database and tables (see attachment), 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
Emp_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_date 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_code to restrict data.)
- Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use Emp_age to
restrict data.)
- Write a SQL query that uses UNION of the two tables to produce a combined result set.
Using the updated database that includes employees from administrative offices and the Delmar location, write the following
queries using the SQL GROUP BY 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 Emp_salary.
- Group employees by salary within their job classification: Select the employees' last names and group them by Emp_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
Attachment:- Database.docx
Attachment:- KudlerFineFoobsDB-Creation.zip