Table: rolando_fonseca_goals
Columns: goal
date
venue
result
competition

Question: What day is miami the venue with 38 goals?
SQL: SELECT "date" FROM rolando_fonseca_goals WHERE "venue" = 'miami' AND "goal" = 38

Question: What competition has 41 goals?
SQL: SELECT "competition" FROM rolando_fonseca_goals WHERE "goal" = 41

Question: What day has 34 goals?
SQL: SELECT "date" FROM rolando_fonseca_goals WHERE "goal" = 34