Table: coach_stats
Columns: team
wins
losses
ties
win_pct

Question: What is the average number of ties for the Detroit Lions team when they have fewer than 5 wins, fewer than 3 losses, and a win percentage of 0.800?
SQL: SELECT AVG("ties") FROM coach_stats WHERE "losses" < 3 AND "wins" < 5 AND "win_pct" = '0.800' AND "team" = 'detroit lions'