SeatGeek Interview Question

SQL pretty simple : Case Statements