For
more course tutorials visit
Use
the database and tables from last week’s assignment to write SQL statements and
enter records into the eEmployee table for workers identified in the employee
files for the administrative offices and the Del Mar store. Check results by
selecting all columns from both tables.
Use
the database and tables from last week’s assignment to write SQL queries using
Between, Like, and Union. Write an SQL query that does the following:
·
Joins two
tables in the example database and uses BETWEEN to restrict record selection.
Use salary to restrict data.
·
Joins two
tables in the example database and uses BETWEEN to restrict record selection.
Use hire dates to restrict data.
·
Joins two
tables in the example database and uses LIKE to restrict record selection. Use
telephone area codes to restrict data.
·
Joins two
tables in the example database and uses LIKE to restrict record selection. Use
age to restrict data.
·
Uses the UNION
of the two tables to produce a third table.
Use
the updated database to write the following queries, using the SQL GROUP
statement:
·
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.
Note the
submission of all individual assignments requires that you post your individual
SQL exercise using a Microsoft Word file. If you are using SQL Server you must
cut and paste your results in tn a Microsoft Word file. You must also include each SQL statement that
you have developed before showing the results set of each query. .
No comments:
Post a Comment