Carnival Cruise Line interview question

SQL Queries (Joins, CTEs, Window fxns)