CREATE TABLE table_name_97 (seasons_completed INT, finals_appearances VARCHAR, division_titles VARCHAR, playoff_appearances VARCHAR)

What is the average number of seasons completed of the team with less than 1 division titles, 0 playoff appearances, and more than 0 finals appearances?
SELECT AVG(seasons_completed) FROM table_name_97 WHERE division_titles < 1 AND playoff_appearances = 0 AND finals_appearances > 0
SELECT AVG("seasons_completed") FROM "table_name_97" WHERE "division_titles" < 1 AND "finals_appearances" > 0 AND "playoff_appearances" = 0