Question $6$

$10$

Points

We would like to know which weekday, $($Mon$,$ Tues. Wed, etc.$)$ that we made the most sales during this month. Add a new column to get the Name of Day from the "SaleDate" field. You can find this under "Add Column" $->$ "Date" $->$"Day"$->$ "Name of Day".

Now, use the GROUP BY function to find total quantity sold by the day of the week. What was the total quantity sold on Mondays?

$128$

Integer, decimal, or E notation allowed

Question $7$

$10$

Points

Merge your Sales table with the Product table so that that you can add in the product name and price for the sales. Recall that when merging tables, linking fields must have the same field type $-$ you may have to check for this.

Determine which Product generated the most in cash value. $($It may take a few steps to determine that $...$ including a calculated custom column and a GROUP BY$.)$

Mango Tango

Berry Burst

Pineapple Punch

Fresh Fusion

Question $8$

$10$

Points

Determine which Product generated the most in cash value on Mondays.

Mango Tango

Berry Burst

Pineapple Punch

Fresh Fusion