Table: federer_2005_season
Columns: outcome
no
date
championship
surface
opponent_in_the_final
score_in_the_final

Question: In the championship Miami , United States, what is the score in the final?
SQL: SELECT "score_in_the_final" FROM federer_2005_season WHERE "championship" = 'Miami , United States'

Question: Andy Roddick is the opponent in the final on what surface?
SQL: SELECT "surface" FROM federer_2005_season WHERE "opponent_in_the_final" = 'Andy Roddick'

Question: In the championship Indian Wells, United States (2), who are the opponents in the final?
SQL: SELECT "opponent_in_the_final" FROM federer_2005_season WHERE "championship" = 'Indian Wells, United States (2)'

Question: Marat Safin is the opponent in the final in what championship?
SQL: SELECT "championship" FROM federer_2005_season WHERE "opponent_in_the_final" = 'Marat Safin'

Question: How many championships are there on the date January 9, 2005?
SQL: SELECT COUNT("championship") FROM federer_2005_season WHERE "date" = 'January 9, 2005'