Write SQL statements to enter records into the Employee table for the 6 workers identified in the employee files for the administrative offices and the Del Mar store. Then use the database and tables to write the following queries.
(1) [1 pt] Check results by selecting the required columns from both tables (two separate queries). Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(2) [1 pt] Join two the two tables in the Kudler Fine Foods database and use BETWEEN to restrict record selection. Use salary to restrict data. The output should be arranged by salary high to low.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(3) [1 pt] Join two the two tables in the Kudler Fine Foods database and use BETWEEN to restrict record selection. Use hire dates to restrict data.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(4) [1 pt] Join two the two tables in the Kudler Fine Foods database and use LIKE to restrict record selection. Use Last Name to restrict data.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(5) [1 pt] Join two the two tables in the Kudler Fine Foods database and use a numerical comparison to restrict record selection. Use age to restrict data. The output should be arranged by age low to high.
Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(6) [1 pt] Use the ‘IN’ operator to find specific ages in a list from the Employee table. Pick specific ages of your choice. Display columns: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(7) [1 pt] Join two the two tables in the Kudler Fine Foods database and obtain only the employees’ last name and EEO-1 arranging the output by EEO-1 classification. Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(8) [1 pt] Join two the two tables in the Kudler Fine Foods database and use employees’ last name, salary and EEO-1 arranging them by salary (low to high). Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(9) [1 pt] Join two the two tables in the Kudler Fine Foods database and use employees’ last names, Exempt/Non-Exempt status arranging them by the status. Display the following columns: From the Job_Title table: Job_Title_ID, Job_Title, EE0-1 classification, Exempt/non-Exempt status. From the Employee_Table: Employee_ID, Last Name, First Name, Salary, age, Hire Date.
(10) [1 pt] Join two the two tables in the Kudler Fine Foods database and use employees’ last names, arranging them by salary, job titles. The query must include a range of salaries and a specific status. You should pick a range and status so that there would be more than one record output. The output should display only the last name, salary and job title columns.
Provide the SQL and screen shot of the results of each of the above and submit these in a .doc.
