Table: nfl_coaches
Columns: coach
first_yr
last_yr
w_l
g_500
yr_plyf
g_plyf
w_plyf
l_plyf

Question: What is the highest w plyf with a first yr before 1960, a G plyf greater than 0, a G > .500 less than 43, and a w-l% less than 0.578?
SQL: SELECT MAX("w_plyf") FROM nfl_coaches WHERE "first_yr" < 1960 AND "g_plyf" > 0 AND "g_500" < 43 AND "w_l" < 0.578

Question: What is the sum of the yr plyf of coach ed robinson, who has a G plyf of 0?
SQL: SELECT SUM("yr_plyf") FROM nfl_coaches WHERE "g_plyf" = 0 AND "coach" = 'ed robinson'

Question: What is the total number of yr plyf with a G plyf less than 0?
SQL: SELECT COUNT("yr_plyf") FROM nfl_coaches WHERE "g_plyf" < 0

Question: Who is the coach with a w-l% greater than 0.516, a first yr before 1925, a yr plyf greater than 2, and a last yr in 1967?
SQL: SELECT "coach" FROM nfl_coaches WHERE "w_l" > 0.516 AND "first_yr" < 1925 AND "yr_plyf" > 2 AND "last_yr" = 1967

Question: What is the average last yr with an l plyf less than 0?
SQL: SELECT AVG("last_yr") FROM nfl_coaches WHERE "l_plyf" < 0

Question: What is the earliest last year with a yr plyf less than 0?
SQL: SELECT MIN("last_yr") FROM nfl_coaches WHERE "yr_plyf" < 0