Table: match_stats
Columns: goal
date
venue
score
result
competition

Question: How many goals have a Date of december 4, 2010, and a Score of 1-0?
SQL: SELECT COUNT("goal") FROM match_stats WHERE "date" = 'december 4, 2010' AND "score" = '1-0'

Question: Which venue has a Competition of 2008 myanmar grand royal challenge cup?
SQL: SELECT "venue" FROM match_stats WHERE "competition" = '2008 myanmar grand royal challenge cup'

Question: Which venue has a Goal of 4?
SQL: SELECT "venue" FROM match_stats WHERE "goal" = 4

Question: What is the largest goal with a Score of 3-0?
SQL: SELECT MAX("goal") FROM match_stats WHERE "score" = '3-0'