Eight questions that need the patterns from this unit. Decide first what shape the answer should have: one row per group (aggregate), one value per original row (transform, rank, cumsum), or some of the original rows (filter, top N).
cafe has a total column (quantity times unit price) and is in time order. rentals is in time order too.