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

Question: What is the total difference for teams that played less than 6 games?
SQL: SELECT SUM("diff") FROM world_club_champ_2 WHERE "played" < 6

Question: What is the highest number of games played for teams that lost over 5 games and had an against total of 228?
SQL: SELECT MAX("played") FROM world_club_champ_2 WHERE "lost" > 5 AND "against" = 228

Question: How many games lost for team(s) with less than 4 paints and against total of over 340?
SQL: SELECT COUNT("lost") FROM world_club_champ_2 WHERE "points" < 4 AND "against" > 340