Exercise: MS Access Queries 5
(From stores_clean database)
-
How many product types have the customers bought?
-
What CommissionAmounts (in money) have we got for each Transaction?
-
What is the total commission amount collected in January?
-
Crosstab query:
-
row: transactionID
-
column: ItemID
-
value: number of transactions (use count for aggregation)
-
filter: total spent in the transaction >20000
- <fac_num>_name_crosstab.jpg, upload the file screenshot
-
Last modified: Wednesday, 20 April 2022, 12:27 PM