Table: malcolm_in_middle_viewers
Columns: season
season_premiere
season_finale
tv_season
ranking
viewers_in_millions

Question: What season was the finale that aired on May 23, 2004?
SQL: SELECT "tv_season" FROM malcolm_in_middle_viewers WHERE "season_finale" = 'May 23, 2004'

Question: What TV season was the 1st season?
SQL: SELECT "tv_season" FROM malcolm_in_middle_viewers WHERE "season" = '1st'

Question: When was the 3rd season premiere originally aired?
SQL: SELECT "season_premiere" FROM malcolm_in_middle_viewers WHERE "season" = '3rd'

Question: What was the 2nd's season's ranking?
SQL: SELECT "ranking" FROM malcolm_in_middle_viewers WHERE "season" = '2nd'

Question: When did the season premiere that saw 8.4 million viewers first air?
SQL: SELECT "season_premiere" FROM malcolm_in_middle_viewers WHERE "viewers_in_millions" = '8.4'

Question: When did the season finale for the January 9, 2000 season premiere first air?
SQL: SELECT "season_finale" FROM malcolm_in_middle_viewers WHERE "season_premiere" = 'January 9, 2000'