Devam Ediyor

503312 Week 3

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 selecting all columns from both tables.

1) Use the database and tables from last week's assignment to write SQL Select queries using Between, Like with Joins:

a. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.

b. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.

c. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.

d. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.

e. Write a SQL query that joins the two tables to produce a third table. Use Select Into.

f. Deliverable: Save each SQL Statement for the above in a Word file and post using the Assignments tab with your week 3 individual assignments.

2) Use the updated database to write the following queries:\

a. Select employees' including last names and order them by EEO-1 classification.

b. Select employees' including last names and order them by salary.

c. Select employees' last names and order them by salary in their EEO-1 classification.

d. Count employees grouped by Exempt/Non-Exempt Status.

e. Count employees grouped by their EEO-1 classification.

f. Deliverable: Save each SQL Statement for the above in a Word file and post using the Assignments tab with your week 3 individual assignments.

Beceriler: Her şey Kabul, SQL

Daha fazlasını görün: salary exempt, non exempt employees, non exempt employee, non exempt, exempt status, exempt salary, exempt employees, exempt employee, hire workers, hire employees, hire age, eeo, write sql queries, last names, sql select order, word query sql, save data table file, word database sql, data table save file, tab count, count word files, sql employee database, employees database sql, employee database sql, save codes database

İşveren Hakkında:
( 4 değerlendirme )

Proje NO: #2249236

Seçilen:

djain01

as discussed

2 gün içinde 35$ USD
(102 Değerlendirme)
6.0