KrazyBee interview question

Joins using different queries, and time complexities.