Which authors belong to the institution "Google"? Show the first names and last names?
SELECT DISTINCT t1.fname ,  t1.lname FROM authors AS t1 JOIN authorship AS t2 ON t1.authid   =   t2.authid JOIN inst AS t3 ON t2.instid   =   t3.instid WHERE t3.name   =   "Google"
authors belong to the institution refers to a JOIN between authors, authorship, and inst tables; first names and last names refer to SELECT DISTINCT t1.fname, t1.lname; institution 'Google' refers to WHERE t3.name = 'Google';