BluePi Interview Question

Question to write a query using join