InComm Interview Question

White an SQL query for this scenario...