SeatGeek interview question

sql question: how to query xxxxx