Show me the name of all the institutions?
select name from inst
show me the name of all the authors?
select fname, lname from authors
Give me the first names and last names of those belong to the "University of Oxford".
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 = "University of Oxford"