CREATE TABLE table_name_63 (ties NUMBER, team VARCHAR2, win_pct VARCHAR2, losses VARCHAR2, wins VARCHAR2)

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?
SELECT AVG(ties) FROM table_name_63 WHERE losses < 3 AND wins < 5 AND win_pct = "0.800" AND team = "detroit lions"
SELECT AVG("ties") FROM "table_name_63" WHERE "0.800" = "win_pct" AND "detroit lions" = "team" AND "losses" < 3 AND "wins" < 5