Table: world_club_champ
Columns: club
played
lost
drawn
against
diff
points

Question: What is the maximum number of draws when the diff is smaller than 186, points are fewer than 12 and games played fewer than 6?
SQL: SELECT MAX("drawn") FROM world_club_champ WHERE "diff" < 186 AND "points" < 12 AND "played" < 6

Question: What is the average diff when games played are more than 6?
SQL: SELECT AVG("diff") FROM world_club_champ WHERE "played" > 6

Question: What is the highest draws when more than 6 are played and the points against are 54?
SQL: SELECT MAX("drawn") FROM world_club_champ WHERE "against" = 54 AND "played" > 6

Question: What is the maximum number of points against when the team has more than 0 losses and plays fewer than 6 games?
SQL: SELECT MAX("against") FROM world_club_champ WHERE "lost" > 0 AND "played" < 6

Question: What is the number of games played for the team with 12 points and an against smaller than 52?
SQL: SELECT AVG("played") FROM world_club_champ WHERE "points" = 12 AND "against" < 52