Table: liechtenstein_badminton_champs
Columns: year
mens_singles
womens_singles
mens_doubles
womens_doubles
mixed_doubles

Question: In 2004, where the womens singles is daniela kressig who is the mens singles
SQL: SELECT "mens_singles" FROM liechtenstein_badminton_champs WHERE "womens_singles" = 'Daniela Kressig'

Question: What is the most current year where the women's doubles champions are astrid eidenbenz claudia jehle
SQL: SELECT MAX("year") FROM liechtenstein_badminton_champs WHERE "womens_doubles" = 'Astrid Eidenbenz Claudia Jehle'

Question: In the year 2006, the womens singles had no competition and the mens doubles were roland hilti kilian pfister, what were the womens doubles
SQL: SELECT "womens_doubles" FROM liechtenstein_badminton_champs WHERE "womens_singles" = 'no competition' AND "mens_doubles" = 'Roland Hilti Kilian Pfister' AND "year" = 2006

Question: In 2001, where the mens singles is armand jehle and the womens singles is michaela ritter, who are the mixed doubles
SQL: SELECT "mixed_doubles" FROM liechtenstein_badminton_champs WHERE "womens_singles" = 'Michaela Ritter' AND "mens_singles" = 'Armand Jehle'

Question: In 1987 who was the mens singles
SQL: SELECT "mens_singles" FROM liechtenstein_badminton_champs WHERE "year" = 1987