New questions on the cafe, ticket, booking and staff tables. Every answer uses mutate(), case_when(), summarise(), group_by() or count(), often several in a chain.
Before writing, say the shape of the answer out loud: one row per what, with which columns? Then watch for the unit's traps: sum() inside mutate(), the grouping that summarise() leaves behind, case_when() order and missing values.