Joining bookings for revenue by outcome

The pilot worked, so the Sales Director is rolling the space out to the whole team. His first question can't be answered from payments alone: he wants revenue split by booking outcome (confirmed, completed, canceled).

To connect the two tables, Genie needs an explicit relationship between them. You'll add the bookings table, curate the columns that could be confused with payments, and define the join so that cross-table questions work.