Kudler Fine Foods Database(Sql)

Kudler Fine Foods Database

Week 3 Assignment

University at Phoenix

POS/410

Vic Echeverria

Outline:

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by creating queries to select all columns from each table.

Use the database and tables from last week’s assignment to write SQL queries using Between and Like. Write an SQL query for each of the following:

•         Join the two tables in the example database and use BETWEEN to restrict record selection. Use salary to restrict data.

•         Join the two tables in the example database and use BETWEEN to restrict record selection. Use hire date to restrict data.

•         Join the two tables in the example database and use LIKE to restrict record selection. Use telephone area code to restrict data.

•         Joins the two tables in the example database and use LIKE to restrict record selection. Use age to restrict data.

Use the updated database to write the following queries, using the GROUP BY clause:

•         Select employees’ last names and group them by EEO-1 classification.

•         Select employees’ last names and group them by salary.

•         Select employees’ last names and group them by salary in their EEO-1 classification.

•         Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.

--Insert Statement for Administrative Offices and Del Mar staff

Insert into Employee (Employee_ID, Last_Name,First_Name,Address,City,State,Area_Code,Telephone_nm,Hire_Dt,EEO1,Salary,Gender,Age,JobTitle_Key)

VALUES

('8','McNamara','Juanita', '923 Parkway', 'Roway', 'CA', '614','5550290',...