View the step-by-step solution to:

Use the database and tables from the Week Two assignment and insert records into the Employee table for workers identified in the employee files for


Use the database and tables from the Week Two assignment and insert records into the Employee table for workers identified in the employee files for the Del Mar and Encinitas stores. Select all columns from all tables via a single join query to show 17 employee records and their associated jobs and EEO-1 classifications.


Write SQL SELECT queries using BETWEEN, LIKE, and UNION. Write SQL queries that do the following:

  • Joins two tables in your Kudler database and uses BETWEEN to restrict record selection. Use salary to restrict data to employees earning an hourly salary (or its equivalent) between $6 and $10.
  • Joins two tables in your Kudler database and uses BETWEEN to restrict record selection. Use hire dates to restrict data to employees hired between 01/01/2003 and 12/31/2003.
  • Joins two tables in your Kudler database and uses LIKE to restrict record selection. Use telephone area codes to restrict data to employees with a telephone area code that contains a 6 somewhere in the number.
  • Joins two tables in your Kudler database and uses LIKE to restrict record selection. Use age to restrict data to employees in their 20s.
  • Uses the UNION of two tables to produce a third table using either SELECT...INTO to persist the table or just a SELECT to show the output of the UNION.

Use your current database to write the following queries, using the SQL GROUP or ORDER statement to sort the results of your query as described below. Each query results should always have the same number of records as you have in your employee table.

  • Select employees' last names and EEO-1 classifications and group them by EEO-1 classification.
  • Select employees' last names and salaries and group them by salary.
  • Select employees' last names, salaries, and EEO-1 classifications and group them by salary within their EEO-1 classification.
  • Select employees' last names, salaries, job titles, and job exemption statuses and group them by salary within job titles, grouped within exempt and non-exempt status.

Take a screen shot of the SQL statements and results.

Use WinZip, PKZIP or alternative to compress (zip up) all screenshots into one file and submit to the assignments link.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question