Task 3 - Generate a Bar Chart Report

You are tasked to generate a bar chart report showing monthly sales for each BikeStores

location in the year 2017. Use the following guidance document to generate the bar chart

report:

Creating a BikeStores Bar Chart Report

Describe how the query contained in the common table expression (CTE) works. Are

correlated or uncorrelated subqueries leveraged? Are the query results filtered? If yes, how

are the results filtered? Are table joins used in the query? If yes, what tables are linked

together? Are aggregate functions leveraged in the query? If yes, describe what results are

being sought along with the applicable grouping parameters.

Examine the generated bar chart report. What information can be drawn from this report?

What assertions can be made from this report?