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

Question: What is the fewest loses for the club that is below 8 in position, and had played less than 30 games?
SQL: SELECT MIN("loses") FROM lff_lyga_2001 WHERE "position" < 8 AND "games_played" < 30

Question: What is the loses total when there is less than 4 draws, less than 105 conceded goals, less than 38 goals scored, and the club is positioned greater than 2?
SQL: SELECT SUM("loses") FROM lff_lyga_2001 WHERE "draws" < 4 AND "goals_conceded" < 105 AND "position" > 2 AND "goals_scored" < 38

Question: How many total goals conceded are there when the points are greater than 58, less than 27 wins, and less than 1 draws?
SQL: SELECT SUM("goals_conceded") FROM lff_lyga_2001 WHERE "points" > 58 AND "wins" < 27 AND "draws" < 1

Question: How many total goals scored when less than 30 games have been played?
SQL: SELECT COUNT("goals_scored") FROM lff_lyga_2001 WHERE "games_played" < 30

Question: When less than 30 games have been played what is the average goals scored?
SQL: SELECT AVG("goals_scored") FROM lff_lyga_2001 WHERE "games_played" < 30