Table: premat_stats
Columns: season
series
team
races
wins
poles
f_laps
podiums
points
position

Question: Which position had 3 podiums and F/laps of 4?
SQL: SELECT "position" FROM premat_stats WHERE "podiums" = '3' AND "f_laps" = '4'

Question: What is the number of races associated with Team ASM and 0 poles?
SQL: SELECT "races" FROM premat_stats WHERE "poles" = '0' AND "team" = 'asm'

Question: Which team had 1 race, 1 F/lap and in the series 24 hours of Nurburgring?
SQL: SELECT "team" FROM premat_stats WHERE "races" = '1' AND "f_laps" = '1' AND "series" = '24 hours of nurburgring'

Question: What is the number of podiums associated with 4 wins?
SQL: SELECT "podiums" FROM premat_stats WHERE "wins" = '4'

Question: What is the number of races associated with 7 podiums and a position of 4th?
SQL: SELECT "races" FROM premat_stats WHERE "position" = '4th' AND "podiums" = '7'

Question: What is the F/Laps value associated with a position of 3rd?
SQL: SELECT "f_laps" FROM premat_stats WHERE "position" = '3rd'