Question: The full SQL code will help or some screenshots using Microsoft Access. Using built - in and aggregate functions, show the total quantity of sales
The full SQL code will help or some screenshots using Microsoft Access.
Using builtin and aggregate functions, show the total quantity of sales by month.
Select the Quantity from the SalesLineItems table and the SaleDate from the Sales table. You will need to join the Sales and SalesLineItems tables.
Using the expression builder to apply a date function to the SaleDate field to display the month name only.
In the design view, click on Builder in the Query Setup group on the Query Tools Design tab on the ribbon to open the expression builder for the date field. Expand the Functions group. Choose Builtin Functions. Select the DateTime Category and use the MonthName and Month Expression Values.
Use the total row to group by month and sum the Quantity.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
