Table: macau_open_badminton
Columns: year
mens_singles
womens_singles
mens_doubles
womens_doubles
mixed_doubles

Question: Who are the mens doubles and womens singles is wang shixian?
SQL: SELECT "mens_doubles" FROM macau_open_badminton WHERE "womens_singles" = 'Wang Shixian'

Question: Who is the mens singles and womens singlses is wang shixian?
SQL: SELECT "mens_singles" FROM macau_open_badminton WHERE "womens_singles" = 'Wang Shixian'

Question: Who are the mens doubles and and mens singles is lee hyun-il?
SQL: SELECT "mens_doubles" FROM macau_open_badminton WHERE "mens_singles" = 'Lee Hyun-il'

Question: Who are the mens singles and womens singles with sun yu?
SQL: SELECT "mens_singles" FROM macau_open_badminton WHERE "womens_singles" = 'Sun Yu'