Table: canadian_open_badminton
Columns: year
men_s_singles
women_s_singles
men_s_doubles
women_s_doubles
mixed_doubles

Question: What year did dave f. mctaggart win the men's singles and robert b. williams ethel marshall win the mixed doubles?
SQL: SELECT MAX("year") FROM canadian_open_badminton WHERE "men_s_singles" = 'dave f. mctaggart' AND "mixed_doubles" = 'robert b. williams ethel marshall'

Question: Who won the women's singles before 1958 when dave f. mctaggart won the men's singles?
SQL: SELECT "women_s_singles" FROM canadian_open_badminton WHERE "men_s_singles" = 'dave f. mctaggart' AND "year" < 1958

Question: Who won the men's singles in 1958?
SQL: SELECT "men_s_singles" FROM canadian_open_badminton WHERE "year" = 1958

Question: Who won the mixed doubles in 1957 when judy devlin won the women's singles?
SQL: SELECT "mixed_doubles" FROM canadian_open_badminton WHERE "women_s_singles" = 'judy devlin' AND "year" = 1957