Write a query to show the quantity of items sold by each department. Sort the results by department name.

Using the query you wrote in Question $1,$ create a data visualization $($e$.$g$.,$ a bar chart$)$ showing all departments and the number of items each of them sold. Using a markdown cell, explain what you observe from the analysis.

Write a query to show the number of orders placed in each year in which at least one order was placed. Hint: Search online to learn about MySQL$$s YEAR$()$ function to query data.

Using the query you wrote in Question $3,$ create a data visualization $($e$.$g$.,$ a line graph$)$ showing all years and the number of orders placed during each year, to see if there is a trend in ordering. Using a markdown cell, explain what you observe from the analysis.