Bazaarvoice interview question

write a query using mySQL to find data held on several tables