Table: ppl_teams_2
Columns: team
played
drawn
lost
points

Question: How many goes played fot hteam that lost less than 12 games, drew 5, and had over 37 points?
SQL: SELECT "played" FROM ppl_teams_2 WHERE "lost" < 12 AND "points" > 37 AND "drawn" = 5

Question: How many games lost for the team that drew 5 times and had over 41 points?
SQL: SELECT AVG("lost") FROM ppl_teams_2 WHERE "drawn" = 5 AND "points" > 41

Question: How many games played for the army team with over 51 points and under 5 games drawn?
SQL: SELECT COUNT("played") FROM ppl_teams_2 WHERE "drawn" < 5 AND "team" = 'army' AND "points" > 51

Question: How many points for the navy team that lost over 11?
SQL: SELECT SUM("points") FROM ppl_teams_2 WHERE "team" = 'navy' AND "lost" > 11