Table: er_tv_ratings
Columns: season
season_premiere
season_finale
tv_season
viewer_rank
households_viewers_in_millions

Question: What season had a viewer rank of #4?
SQL: SELECT COUNT("season") FROM er_tv_ratings WHERE "viewer_rank" = '#4'

Question: Which season had less than 25.4 viewers and had a viewer rank of #6?
SQL: SELECT MIN("season") FROM er_tv_ratings WHERE "households_viewers_in_millions" < 25.4 AND "viewer_rank" = '#6'

Question: When did the season premiere that had a viewer rank of #6?
SQL: SELECT "season_premiere" FROM er_tv_ratings WHERE "viewer_rank" = '#6'