Domanda di colloquio di Smoothstack

Asked to come up with an SQL query given a few table attributes