user: ### NOW ANSWER:
Question: 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?
Columns: ['Team', 'First NHL season', 'Last NHL season', 'Seasons completed', 'Playoff appearances', 'Series won', 'Finals appearances', 'Division titles', 'Conference titles', 'Stanley Cup Championships']
Types: ['text', 'text', 'text', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Montreal Canadiens', '1917–18', 'Active', 91.0, 76.0, 86.0, 34.0, 30.0, 5.0, 23.0]
SQL:

assistant: SELECT AVG("Seasons completed") FROM "Table" WHERE "Division titles" < 1.0 AND "Playoff appearances" = 0.0 AND "Finals appearances" > 0.0;