Table: acg_parnell_college
Columns: name
gender
local_board
suburb
authority
decile
roll

Question: What name shows as private authority and hibiscus and bays local board ?
SQL: SELECT "name" FROM acg_parnell_college WHERE "authority" = 'private' AND "local_board" = 'hibiscus and bays'

Question: What is the name when the local board is albert–eden, and a Decile of 9?
SQL: SELECT "name" FROM acg_parnell_college WHERE "local_board" = 'albert–eden' AND "decile" = '9'

Question: What is the name of the suburb with a roll of 741?
SQL: SELECT "suburb" FROM acg_parnell_college WHERE "roll" = 741

Question: What gender has a local board of albert–eden with a roll of more than 232 and Decile of 5?
SQL: SELECT "gender" FROM acg_parnell_college WHERE "local_board" = 'albert–eden' AND "roll" > 232 AND "decile" = '5'