CREATE TABLE table_name_56 (roll VARCHAR2, decile VARCHAR2, authority VARCHAR2, area VARCHAR2)

What is the total number of Rolls of State schools in Hapuku with a Decile greater than 4?
SELECT COUNT(roll) FROM table_name_56 WHERE authority = "state" AND area = "hapuku" AND decile > 4
SELECT COUNT("roll") FROM "table_name_56" WHERE "area" = "hapuku" AND "authority" = "state" AND "decile" > 4