Table: island_games_badminton
Columns: year
men_s_singles
women_s_singles
men_s_doubles
women_s_doubles
mixed_doubles

Question: Name the women's singles for 1991
SQL: SELECT "women_s_singles" FROM island_games_badminton WHERE "year" = 1991

Question: Name the women's doubles for mixed doubles of no competition
SQL: SELECT "women_s_doubles" FROM island_games_badminton WHERE "mixed_doubles" = 'no competition'

Question: Name the women's singles for glenn macfarlane mark leadbeater
SQL: SELECT "women_s_singles" FROM island_games_badminton WHERE "men_s_doubles" = 'glenn macfarlane mark leadbeater'

Question: Name the women's doubles for frederik kjærholm elsner
SQL: SELECT "women_s_doubles" FROM island_games_badminton WHERE "men_s_singles" = 'frederik kjærholm elsner'

Question: Name the year for anton kriel chris cotillard
SQL: SELECT "year" FROM island_games_badminton WHERE "men_s_doubles" = 'anton kriel chris cotillard'

Question: Name the men's doubles for years before 1999 and elizabeth cann for women's singles
SQL: SELECT "men_s_doubles" FROM island_games_badminton WHERE "year" < 1999 AND "women_s_singles" = 'elizabeth cann'