Table: nashville_sounds_managers
Columns: manager
years
games
wins
losses

Question: What was Jim Hoff's sum of losses and a wins smaller than 12?
SQL: SELECT SUM("losses") FROM nashville_sounds_managers WHERE "manager" = 'jim hoff' AND "wins" < 12

Question: What was the average of games that were one in 1978 that were smaller than 141?
SQL: SELECT AVG("wins") FROM nashville_sounds_managers WHERE "years" = '1978' AND "games" < 141

Question: What was the sum of Richie Hebner winning games that were smaller 34?
SQL: SELECT SUM("games") FROM nashville_sounds_managers WHERE "manager" = 'richie hebner' AND "wins" < 34

Question: What was the average of wins with manager George Scherger smaller than 3 and losses smaller than 1?
SQL: SELECT AVG("wins") FROM nashville_sounds_managers WHERE "games" < 3 AND "manager" = 'george scherger' AND "losses" < 1