Cox Communications interview question

SQL queries with nesting.