Part $1$:

Use the Lab: Structured Query Language $($SQL$)$ Queries with Data Manipulation

Language $($DML$)$ Worksheet file $($found in the Resources section$),$ populate the tables you

created above using SQL Insert statements. Note that there are multiple sheets in this workbook.

Each sheet contains data for a separate table.

You may find it easier to create formulas in your Excel file to generate $$insert$$ statements and

then paste those queries into a sql script file. Conversely, you may find it easier to pull the data

from Excel into Microsoft Access and import it directly into SQL Server using ODBC. To use

this latter technique, refer to the $$How to Import Data from Access to SQL Server$$ document in

your lab folder.

Once the data are loaded, execute the following SELECT statements in SQL Server and paste a

screenshot of your results below each SELECT query in the Lab: SQL Queries with DML

Template, located on the assignment page. Make sure your screenshot includes the bottom

status bar in the query results window that indicates the number of rows displayed.

Select $*$ from Regions

Select $*$ from Countries

Select $*$ from Offices

Select $*$ from Employees

Select $*$ from ContractTypes

Select $*$ from Clients

Select $*$ from Contracts

Select $*$ from Projects

Select $*$ from EmployeeProjectAssignments

Select $*$ from Workhours