Submitted by: Submitted by 5532521ss
Views: 246
Words: 877
Pages: 4
Category: Science and Technology
Date Submitted: 03/08/2013 08:53 AM
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',...