Table: nypd_ratings
Columns: season
premiere
finale
episodes
timeslot
rank
viewers_in_households

Question: When was the premiere of the show that had a rank of #7?
SQL: SELECT "premiere" FROM nypd_ratings WHERE "rank" = '#7'

Question: When was the finale played when the show premiered on September 24, 2002?
SQL: SELECT "finale" FROM nypd_ratings WHERE "premiere" = 'september 24, 2002'

Question: What is the minimum number of views that watched the show when there was more than 22 episodes and the finale was on May 23, 1995?
SQL: SELECT MIN("viewers_in_households") FROM nypd_ratings WHERE "finale" = 'may 23, 1995' AND "episodes" > 22