Table: frank_loughran_match_stats
Columns: date
venue
result
goals
competition

Question: On what date was a friendly match held at Auckland?
SQL: SELECT "date" FROM frank_loughran_match_stats WHERE "competition" = 'friendly match' AND "venue" = 'auckland'

Question: What were the goals at Sydney?
SQL: SELECT "goals" FROM frank_loughran_match_stats WHERE "venue" = 'sydney'