Table: jacob_mulenga_match_stats
Columns: date
venue
score
result
competition

Question: What is the date of Competition of 2008 africa cup of nations?
SQL: SELECT "date" FROM jacob_mulenga_match_stats WHERE "competition" = '2008 africa cup of nations'

Question: What is the score on 22 january 2008?
SQL: SELECT "score" FROM jacob_mulenga_match_stats WHERE "date" = '22 january 2008'

Question: Which venue was used 22 january 2008?
SQL: SELECT "venue" FROM jacob_mulenga_match_stats WHERE "date" = '22 january 2008'

Question: What result has a Score of 1–0, and a Competition of 2014 fifa world cup qualification?
SQL: SELECT "result" FROM jacob_mulenga_match_stats WHERE "score" = '1–0' AND "competition" = '2014 fifa world cup qualification'

Question: What date was the Competition of 2014 fifa world cup qualification, with a Score of 1–0?
SQL: SELECT "date" FROM jacob_mulenga_match_stats WHERE "competition" = '2014 fifa world cup qualification' AND "score" = '1–0'