SeatGeek interview question

SQL pretty simple : Case Statements