Table: wilshere_stats
Columns: national_team
club
year
apps
goals

Question: Which Goals have Apps smaller than 1?
SQL: SELECT AVG("goals") FROM wilshere_stats WHERE "apps" < 1

Question: Which National team has a Year of total?
SQL: SELECT "national_team" FROM wilshere_stats WHERE "year" = 'total'

Question: How many Goals have a National team of england, and Apps smaller than 6, and a Year of 2012?
SQL: SELECT SUM("goals") FROM wilshere_stats WHERE "national_team" = 'england' AND "apps" < 6 AND "year" = '2012'

Question: Which National team has a Club of arsenal, and Apps smaller than 4, and a Year of 2010?
SQL: SELECT "national_team" FROM wilshere_stats WHERE "club" = 'arsenal' AND "apps" < 4 AND "year" = '2010'