Table: bayswater_school
Columns: name
years
gender
area
authority
decile
roll

Question: Who has a roll value of 422?
SQL: SELECT "name" FROM bayswater_school WHERE "roll" = 422

Question: In what area is the decile value 10?
SQL: SELECT "area" FROM bayswater_school WHERE "decile" = 10

Question: What is the highest decile value with a roll greater than 301 in Hauraki?
SQL: SELECT MAX("decile") FROM bayswater_school WHERE "roll" > 301 AND "area" = 'hauraki'