Exercise: MS Access Queries 6
1. What is the total number of transactions where commission amount > 0
2. Total number of stores where our customers have spent less than 100000
3. Make a list of all stores of relative turnover = total spent by customers / StoreTurnover and find if there are inconsistencies - input the suspicious store IDs, separated by comma in the form
4. Make a list of the items which are sold more than 25 times, how many times is the thirdmost item sold?
5. Calculate Average transaction size by the different transaction types, sorted in ascending order of type category context
https://forms.gle/BpCr8tBhX6Xx7Bow6
(Please, post p. 5 as a image submission to the form, named <fac_num>_name_task5.jpg).
Last modified: Wednesday, 20 April 2022, 12:27 PM