T-Mobile interview question

SQL questions given a hypothetical dataset