CREATE TABLE table_69119 ("Name" CLOB, "Years" CLOB, "Gender" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

What is the roll number of Te Puke Intermediate, which has a decile of 4?
SELECT "Roll" FROM table_69119 WHERE "Decile" = '4' AND "Name" = 'te puke intermediate'
SELECT "Roll" FROM "table_69119" WHERE "Decile" = '4' AND "Name" = 'te puke intermediate'