Table: burkhard_ziese
Columns: name
period
matches
wins
draws
losses

Question: Who has 1 win, 1 loss, and has played 2 matches?
SQL: SELECT "name" FROM burkhard_ziese WHERE "wins" = '1' AND "losses" = '1' AND "matches" = '2'

Question: Who has 5 losses and has played 11 matches?
SQL: SELECT "name" FROM burkhard_ziese WHERE "losses" = '5' AND "matches" = '11'

Question: How many matches has Mohammad Al-Shamlan played when there is 1 win?
SQL: SELECT "matches" FROM burkhard_ziese WHERE "wins" = '1' AND "name" = 'mohammad al-shamlan'

Question: How many matches were played when there was 1 draw and 1 win?
SQL: SELECT "matches" FROM burkhard_ziese WHERE "draws" = '1' AND "wins" = '1'