Table: soccer_match_stats
Columns: date
location
lineup
assist_pass
score
result
competition

Question: Which competition has a result of 2-0 in Ferreiras with an assist/pass by Casey Nogueira?
SQL: SELECT "competition" FROM soccer_match_stats WHERE "result" = '2-0' AND "location" = 'ferreiras' AND "assist_pass" = 'casey nogueira'

Question: What is the score with the Lineup match reports?
SQL: SELECT "score" FROM soccer_match_stats WHERE "lineup" = 'match reports'

Question: On what date is there an assist/pass by Shannon Boxx?
SQL: SELECT "date" FROM soccer_match_stats WHERE "assist_pass" = 'shannon boxx'

Question: Which assist/pass is in Ferreiras?
SQL: SELECT "assist_pass" FROM soccer_match_stats WHERE "location" = 'ferreiras'