Bazaarvoice Interview Question

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