user: ### NOW ANSWER:
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?
Columns: ['Team', 'Wins', 'Losses', 'Ties', 'Win Pct.']
Types: ['text', 'real', 'real', 'real', 'text']
Sample row: ['Arizona Cardinals', 2.0, 1.0, 0.0, '0.667']
SQL:

assistant: SELECT AVG("Ties") FROM "Table" WHERE "Losses" < 3.0 AND "Wins" < 5.0 AND "Win Pct." = '0.800' AND "Team" = 'Detroit Lions';