CREATE TABLE conference (cid NUMBER, homepage VARCHAR2, name VARCHAR2)
CREATE TABLE writes (aid NUMBER, pid NUMBER)
CREATE TABLE publication (abstract VARCHAR2, cid NUMBER, citation_num NUMBER, jid NUMBER, pid NUMBER, reference_num NUMBER, title VARCHAR2, year NUMBER)
CREATE TABLE author (aid NUMBER, homepage VARCHAR2, name VARCHAR2, oid NUMBER)
CREATE TABLE domain_author (aid NUMBER, did NUMBER)
CREATE TABLE keyword (keyword VARCHAR2, kid NUMBER)
CREATE TABLE domain_keyword (did NUMBER, kid NUMBER)
CREATE TABLE publication_keyword (kid NUMBER, pid NUMBER)
CREATE TABLE domain (did NUMBER, name VARCHAR2)
CREATE TABLE cite (cited NUMBER, citing NUMBER)
CREATE TABLE domain_conference (cid NUMBER, did NUMBER)
CREATE TABLE journal (homepage VARCHAR2, jid NUMBER, name VARCHAR2)
CREATE TABLE organization (continent VARCHAR2, homepage VARCHAR2, name VARCHAR2, oid NUMBER)
CREATE TABLE domain_journal (did NUMBER, jid NUMBER)
CREATE TABLE domain_publication (did NUMBER, pid NUMBER)

return me the papers in VLDB conference containing keyword ' Information Retrieval ' .
SELECT publication.title FROM conference, keyword, publication, publication_keyword WHERE conference.name = 'VLDB' AND keyword.keyword = 'Information Retrieval' AND publication_keyword.kid = keyword.kid AND publication.cid = conference.cid AND publication.pid = publication_keyword.pid
SELECT "publication"."title" FROM "conference" JOIN "publication" ON "conference"."cid" = "publication"."cid" JOIN "publication_keyword" ON "publication"."pid" = "publication_keyword"."pid" JOIN "keyword" ON "keyword"."keyword" = 'Information Retrieval' AND "keyword"."kid" = "publication_keyword"."kid" WHERE "conference"."name" = 'VLDB'