Table: nhl_team_stats_2
Columns: team
first_nhl_season
last_nhl_season
seasons_completed
playoff_appearances
series_won
finals_appearances
division_titles
conference_titles
stanley_cup_championships

Question: How many division titles does the team with 23 playoff appearances and more than 1 conference titles have?
SQL: SELECT SUM("division_titles") FROM nhl_team_stats_2 WHERE "playoff_appearances" = 23 AND "conference_titles" > 1

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?
SQL: SELECT AVG("seasons_completed") FROM nhl_team_stats_2 WHERE "division_titles" < 1 AND "playoff_appearances" = 0 AND "finals_appearances" > 0