Table: promotion_2008
Columns: date
2nd_bundesliga_16th
3rd_liga_3rd
game_1
game_2

Question: What date has Liga 3rd of Dynamo Dresden?
SQL: SELECT "date" FROM promotion_2008 WHERE "3rd_liga_3rd" = 'dynamo dresden'

Question: What is the 3rd Liga from 2010-11?
SQL: SELECT "3rd_liga_3rd" FROM promotion_2008 WHERE "date" = '2010-11'

Question: What is the 3rd Liga from Game 1 of 0-1 between the years 2008-09?
SQL: SELECT "3rd_liga_3rd" FROM promotion_2008 WHERE "game_1" = '0-1' AND "date" = '2008-09'