What are the paper id of Gibbons?
select distinct paperid from authors as t1 join authorship as t2 on t1.authid = t2.authid where t1.lname = "Gibbons"
Yes
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 = "Northeastern University"
What are the auth id of Ralf?
select authid from authors where fname = "Ralf"
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"