Write SQL queries using BETWEEN, LIKE and UNION
Not what you're looking for?
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.
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.