Zonar Systems interview question

Select from a table. Join on another table. Basic SQL stuff.