b2match interview question

Some easy SQL question that required to do an Inner Join