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 WHERE Division titles < 1 AND Playoff appearances = 0 AND Finals appearances > 0