T$350$M$3-3$: Create aggregated business report datasets to format output and filter data.

Purpose

When creating reports, you often want to show the sums, averages, or counts of certain data fields. SQL has built in aggregate functions that will allow you to calculate these values. You can also retrieve minimum and maximum values from a dataset. Additionally, you often need to modify your database by updating values, removing rows of data, or inserting new data. You will learn how to perform all of these valuable tasks. You will generate aggregated data outputs to address specific problems statements.

Assessment Instructions

It is very important that you watch the Module $3$ videos associated with SQL prior to completing the assessment. Navigate to the Academic Tools area of this Module and select Library then Required Readings to access your texts and videos.

You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio $($SSMS$)$ for this course. You can download the latest versions of these free software products here:

Microsoft SQL Server Express

Microsoft SSMS

The sample database for this module is called BikeStores. The database creation script, installation instructions, and database diagram can be downloaded below:

Create BikeStores Database Script

Instructions for Establishing the BikeStores Database

Bikestores Database Design Diagram

Use the BikeStores database design diagram to formulate an SQL solution for each of the assessment problems.

You will generate a Microsoft Word report from the completed work. Please copy the numbered problem statement into your Microsoft$$ Word$$ report. Below that, enter the SQL text you used to solve the problem. Below that, enter a screenshot of the execution of the SQL showing the code and the result set. Start each problem on a new page.