Problem
1) A list of all purchases made at a particular outlet (for example, 'Egham Main Street'), ordered by time, giving for each the time, the number of different product types purchased, and the total price paid by the customer.
2) A list of all customers who have made a purchase to a total value of more than 100 pounds at the same occasion, giving for each the name, address, the average purchase value, and the maximum purchase value.
3) A list of all products, giving for each the name, the total number of copies in stock across all outlets, and the total number of copies sold. Order the list by number of copies sold in decreasing order.
4) A list of all cities where the total sales of products from category 10 are larger than from category 11, as measured by the total price paid for them. Give for each the city name, the number of outlets in the city, the total sales value for products from category 10, and the total sales value for products from category 11. The list should not contain any repeated cities.