Sierra Wireless interview question

A SQL question using self join