Tell me Brad Lohaus's age.
select age from people where name = "Brad Lohaus"
Where does he work?
select t3.name from employment as t1 join people as t2 on t1.people_id = t2.people_id join company as t3 on t1.company_id = t3.company_id where t2.name = "Brad Lohaus"
How about all the names of the companies and of the employees?
select t3.name, t2.name from employment as t1 join people as t2 on t1.people_id = t2.people_id join company as t3 on t1.company_id = t3.company_id