Table: rockies_2008_game_3
Columns: date
opponent
score
loss
attendance
record

Question: Loss of francis (4–9) has what highest attendance figure?
SQL: SELECT MAX("attendance") FROM rockies_2008_game_3 WHERE "loss" = 'francis (4–9)'

Question: Loss of de la rosa (8–8) has what average attendance?
SQL: SELECT AVG("attendance") FROM rockies_2008_game_3 WHERE "loss" = 'de la rosa (8–8)'

Question: Loss of francis (4–10) happened on what date?
SQL: SELECT "date" FROM rockies_2008_game_3 WHERE "loss" = 'francis (4–10)'