Table: head_of_river_queensland
Columns: crew
open_1st_viii
open_2nd_viii
open_3rd_viii
u16_1st_viii
u16_2nd_viii
u16_3rd_viii
u15_1st_iv
u15_2nd_iv
u15_3rd_iv
u15_4th_iv
u15_5th_iv
u15_6th_iv

Question: what are all the open 1st viii with u15 6th iv being bgs
SQL: SELECT "open_1st_viii" FROM head_of_river_queensland WHERE "u15_6th_iv" = 'BGS'

Question: what are all the u16 2nd viii with u15 3rd iv being bbc
SQL: SELECT "u16_2nd_viii" FROM head_of_river_queensland WHERE "u15_3rd_iv" = 'BBC'

Question: what are all the open 1st viii with u15 4th iv being gt
SQL: SELECT "open_1st_viii" FROM head_of_river_queensland WHERE "u15_4th_iv" = 'GT'

Question: how many crew had u15 3rd iv being bgs and u15 1st iv being acgs and open 1st viii being acgs
SQL: SELECT COUNT("crew") FROM head_of_river_queensland WHERE "u15_3rd_iv" = 'BGS' AND "u15_1st_iv" = 'ACGS' AND "open_1st_viii" = 'ACGS'

Question: what are all the u15 3rd iv with u15 4th iv being bbc
SQL: SELECT "u15_3rd_iv" FROM head_of_river_queensland WHERE "u15_4th_iv" = 'BBC'

Question: how many open 2nd viii had u15 3rd iv being gt
SQL: SELECT COUNT("open_2nd_viii") FROM head_of_river_queensland WHERE "u15_3rd_iv" = 'GT'