papers by Koos Koole
CREATE TABLE paperdataset (
    paperid int,
    datasetid int
)

CREATE TABLE dataset (
    datasetid int,
    datasetname varchar
)

CREATE TABLE paperkeyphrase (
    paperid int,
    keyphraseid int
)

CREATE TABLE paper (
    paperid int,
    title varchar,
    venueid int,
    year int,
    numciting int,
    numcitedby int,
    journalid int
)

CREATE TABLE paperfield (
    fieldid int,
    paperid int
)

CREATE TABLE field (
    fieldid int
)

CREATE TABLE venue (
    venueid int,
    venuename varchar
)

CREATE TABLE cite (
    citingpaperid int,
    citedpaperid int
)

CREATE TABLE author (
    authorid int,
    authorname varchar
)

CREATE TABLE journal (
    journalid int,
    journalname varchar
)

CREATE TABLE writes (
    paperid int,
    authorid int
)

CREATE TABLE keyphrase (
    keyphraseid int,
    keyphrasename varchar
)
SELECT DISTINCT writes.paperid FROM author, writes WHERE author.authorname = 'Koos Koole' AND writes.authorid = author.authorid
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: papers by Koos Koole ### Input: CREATE TABLE paperdataset (
    paperid int,
    datasetid int
)

CREATE TABLE dataset (
    datasetid int,
    datasetname varchar
)

CREATE TABLE paperkeyphrase (
    paperid int,
    keyphraseid int
)

CREATE TABLE paper (
    paperid int,
    title varchar,
    venueid int,
    year int,
    numciting int,
    numcitedby int,
    journalid int
)

CREATE TABLE paperfield (
    fieldid int,
    paperid int
)

CREATE TABLE field (
    fieldid int
)

CREATE TABLE venue (
    venueid int,
    venuename varchar
)

CREATE TABLE cite (
    citingpaperid int,
    citedpaperid int
)

CREATE TABLE author (
    authorid int,
    authorname varchar
)

CREATE TABLE journal (
    journalid int,
    journalname varchar
)

CREATE TABLE writes (
    paperid int,
    authorid int
)

CREATE TABLE keyphrase (
    keyphraseid int,
    keyphrasename varchar
) ### Response: SELECT DISTINCT writes.paperid FROM author, writes WHERE author.authorname = 'Koos Koole' AND writes.authorid = author.authorid