Please i need help with this assignment due today
1, Find a current article about managing data and write a 1-to 2-page paper discussing the article and its relevance to this week's individual assignment.
Assignment: 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
- Disney recently ended a long-standing relationship with Netflix to start its own streaming services. Netflix will eventually no longer be able to stream Disney
- hi i have to do the assignment of that what do you think about the current international system. like the anarchy it good or it is bad. just need about the
- I really need help with how to get there? Any thoughts about that? Or some outlines