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

return me the keywords, which have been contained by more than 100 papers in PVLDB .
SELECT keyword.keyword FROM journal, keyword, publication, publication_keyword WHERE journal.name = 'PVLDB' AND publication_keyword.kid = keyword.kid AND publication.jid = journal.jid AND publication.pid = publication_keyword.pid GROUP BY keyword.keyword HAVING COUNT(DISTINCT (publication.title)) > 100
SELECT "keyword"."keyword" FROM "journal" JOIN "publication" ON "journal"."jid" = "publication"."jid" JOIN "publication_keyword" ON "publication"."pid" = "publication_keyword"."pid" JOIN "keyword" ON "keyword"."kid" = "publication_keyword"."kid" WHERE "journal"."name" = 'PVLDB' GROUP BY "keyword"."keyword" HAVING COUNT(DISTINCT "publication"."title") > 100