Exercise: MS Access queries 2
1. How many customers have invested in Lycos?
2. How many "bottom" customers do we have?
3. What is the average total amount by all top customers?
4. How much total amount have we obtained from Germany?
5. What average amount has all account managers obtained from all customers?
6. Delete all data about cash position with a query. What is the total amount of all positions after that?
2. How many "bottom" customers do we have?
3. What is the average total amount by all top customers?
4. How much total amount have we obtained from Germany?
5. What average amount has all account managers obtained from all customers?
6. Delete all data about cash position with a query. What is the total amount of all positions after that?
7. How many customers have we obtained in 2020? (Using expression builder)
Last modified: Wednesday, 13 April 2022, 11:49 AM