Purchase Solution

Write SQL queries using BETWEEN, LIKE and UNION

Not what you're looking for?

Ask Custom Question

Using the database and tables from the attached file, 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 find all people in their 20's.)

Write a SQL query that uses UNION of the two tables. Be creative.

Using the updated database, write the following queries using the SQL GROUP BY statement and appropriate aggregate statements (when needed):

Write a SQL query that displays the average salary / hourly wage grouped by job_title.

Write a SQL query that displays the number of people in each EE0-1 Classification and the average salary / hourly wage for each classification.

Group employees by EEO classification: Select the employees' last names and group them by EEO-1 Classification

Group employees by salary within their EEO 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.

Attachments
Purchase this Solution

Solution Summary

The expert writes an SQL queries using BETWEEN, LIKE and UNION.

Purchase this Solution


Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Javscript Basics

Quiz on basics of javascript programming language.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.