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

Question: What is the Authority for Kuranui Primary School that is located in the Area of Tirau?
SQL: SELECT "authority" FROM waikato_schools WHERE "area" = 'tirau' AND "name" = 'kuranui primary school'

Question: Which Names have Deciles larger than 7?
SQL: SELECT "name" FROM waikato_schools WHERE "decile" > 7

Question: What Gender are the schools that have a Roll of 135?
SQL: SELECT "gender" FROM waikato_schools WHERE "roll" = '135'

Question: What is the Name of a state Authority that has a Roll of 72?
SQL: SELECT "name" FROM waikato_schools WHERE "authority" = 'state' AND "roll" = '72'