View the step-by-step solution to:

Using the tables from Week Two, write SQL statements and enter the records into the employee table for the workers identified in the Employee Files

Using the tables from Week Two, write SQL statements and enter the records into the employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check the results by selecting all of the columns from both of your tables.
Using the database and tables in Week Two, write SQL queries using '=', Between, and Like:
1. Write a SQL query that joins the two tables in the example database and uses BETWEEN to restrict record selection. Display Name, City, State, and Job Description for all Employees earning a Salary between two values.
2. Write a SQL query that joins the two tables in the example database and uses '=' to restrict record selection. Display Name, Hire Date, Age, and Exempt Status for all Exempt employees.
3. Write a SQL query that joins the two tables in the example database and uses '=' to restrict record selection. Display Name, City, State, Age and Exempt Status and for all Exempt employees that live in a certain State.
4. Write a SQL query that joins the two tables in the example database and uses LIKE to restrict record selection. Display Name, City, Gender, Age and Job Description for all employees from a City beginning with a certain letter.
Using the updated database, write the following queries using the SQL GROUP BY statement:
5. Group employees by Job Description.  Display a count of how many employees have each job description in descending order (descending by count).
6. Group employees by State. Display a list of States that have more than 1 employee. (The result should be only a State name, and no count information).
7. Group employees by Exempt Status.  Display a count of how many employees are Exempt and how many are non-Exempt using a single query.  (Only the counts and Exempt or Non-Exempt should be displayed).

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