task 4 generate a line chart report you are tasked to generate a line
Question
Task 4 - Generate a Line Chart Report
You are tasked to generate a line chart report showing monthly sales for each bike category
in the year 2016. Use the following guidance document to generate the line chart report:
Creating a BikeStores Line 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 line chart report. What information can be drawn from this report?
What assertions can be made from this report?