Table: no_coach_1892
Columns: name
years
seasons
lost
pct

Question: What is the years coached by the person with a win percentage of 0.667 and 380 losses?
SQL: SELECT "years" FROM no_coach_1892 WHERE "pct" = 0.667 AND "lost" = 380

Question: What is the average percent for the coach from 1905 and more than 7 losses?
SQL: SELECT AVG("pct") FROM no_coach_1892 WHERE "years" = '1905' AND "lost" > 7

Question: How many percentages have 20 losses and more than 1 season?
SQL: SELECT COUNT("pct") FROM no_coach_1892 WHERE "lost" = 20 AND "seasons" > 1