CREATE TABLE table_42740 ("Season" TEXT, "Ep #" FLOAT, "Season Premiere" TEXT, "Season Finale" TEXT, "Ranking" TEXT, "Viewers  ( Households in millions ) " TEXT, "Rating" TEXT)

What is the rating of the season 10?
SELECT "Rating" FROM table_42740 WHERE "Season" = 'season 10'
SELECT "Rating" FROM "table_42740" WHERE "Season" = 'season 10'