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

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