Explore BrainMass
Share

Writing SQL Queries Using a Database and Tables

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Write SQL queries (SELECT statements) using BETWEEN, LIKE, UNION, and GROUP.

Using the database and tables (see attachment) write SQL INSERT statements to insert records into the employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check your results by selecting all of the columns from both of your tables.

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.

In Microsoft SQL Server Management Studio, save your SQL statements as .SQL files. Save your SQL output as .RPT files. You will need to post both types of files (.SQL and .RPT).

© BrainMass Inc. brainmass.com December 20, 2018, 3:14 am ad1c9bdddf
https://brainmass.com/computer-science/sql/writing-sql-queries-database-tables-249588

Attachments

Solution Summary

Using the database and tables (provided) the solution writes SQL queries (SELECT statements) using BETWEEN, LIKE, UNION, and GROUP.

$2.19