T-Mobile interview question

A simple SQL with follow up.