Table: soccer_club_stats
Columns: position
club
games_played
wins
draws
loses
goals_scored
goals_conceded
points

Question: What is the highest position of club lietava-2 jonava, which has more than 12 points and more than 7 wins?
SQL: SELECT MAX("position") FROM soccer_club_stats WHERE "points" > 12 AND "club" = 'lietava-2 jonava' AND "wins" > 7

Question: What is the total number of goals of the club with 4 wins and less than 0 draws?
SQL: SELECT COUNT("goals_conceded") FROM soccer_club_stats WHERE "wins" = 4 AND "draws" < 0

Question: What is the total number of games played of the club with less than 40 goals scored, 9 losses, 39 goals conceded, and more than 2 draws?
SQL: SELECT COUNT("games_played") FROM soccer_club_stats WHERE "goals_scored" < 40 AND "loses" = 9 AND "goals_conceded" = 39 AND "draws" > 2

Question: What is the total number of goals scored of the club with more than 3 draws, more than 1 loses, and less than 26 points?
SQL: SELECT COUNT("goals_scored") FROM soccer_club_stats WHERE "draws" > 3 AND "loses" > 1 AND "points" < 26

Question: What is the sum of the position with less than 0 draws?
SQL: SELECT SUM("position") FROM soccer_club_stats WHERE "draws" < 0