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

Question: Name the years for elsthorpe school
SQL: SELECT "years" FROM argyll_east_school WHERE "name" = 'elsthorpe school'

Question: Name the total number of roll for st joseph's school when decile is less than 5
SQL: SELECT COUNT("roll") FROM argyll_east_school WHERE "name" = 'st joseph''s school' AND "decile" < 5

Question: Name the years for porangahau school
SQL: SELECT "years" FROM argyll_east_school WHERE "area" = 'porangahau' AND "name" = 'porangahau school'

Question: Name the gender for elsthorpe school
SQL: SELECT "gender" FROM argyll_east_school WHERE "name" = 'elsthorpe school'