CREATE TABLE authors (authid NUMBER, lname CLOB, fname CLOB)
CREATE TABLE authorship (authid NUMBER, instid NUMBER, paperid NUMBER, authorder NUMBER)
CREATE TABLE papers (paperid NUMBER, title CLOB)
CREATE TABLE inst (instid NUMBER, name CLOB, country CLOB)

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"
SELECT DISTINCT "t1"."fname", "t1"."lname" FROM "authors" "t1" JOIN "authorship" "t2" ON "t1"."authid" = "t2"."authid" JOIN "inst" "t3" ON "Google" = "t3"."name" AND "t2"."instid" = "t3"."instid"