TELUS interview question

Write a SQL query to do X.