SeatGeek Interview Question

sql question: how to query xxxxx