This HW consists of two parts: pivot queries and partitioning.

This HW consists of two parts: pivot queries and partitioning. The pivot part includes three queries. The partition has three problems; the first two require creating a table and inserting three rows of data. Each of these problems should be self-contained; that is, include the DROP command, CREATE command and inserts. The third (and last) problem partitions a table that has already been created and data inserted. This script is included (PartitionHWStart.sql); run this script and then do the tasks (partitioning the table). Turn in a SINGLE .sql file.)

I am adding the SQL file Text in a text document, but just notice that it is the SQL code – PartitionHWStart.txt