Table: mash_ratings
Columns: season
ep
season_premiere
season_finale
ranking
viewers_households_in_millions
rating

Question: What was the ranking for the episode number before 24 that had a rating of 25.7?
SQL: SELECT "ranking" FROM mash_ratings WHERE "ep" < 24 AND "rating" = '25.7'

Question: How many million viewers watched the season finale on March 12, 1979?
SQL: SELECT "viewers_households_in_millions" FROM mash_ratings WHERE "season_finale" = 'march 12, 1979'

Question: What is the rating of the season 10?
SQL: SELECT "rating" FROM mash_ratings WHERE "season" = 'season 10'

Question: What was the rating of the season that had 18.17 million household viewers?
SQL: SELECT "rating" FROM mash_ratings WHERE "viewers_households_in_millions" = '18.17'