Table: tv_show_ratings_9
Columns: episode
rating
share
rating_share_18_49
viewers_millions
rank_timeslot
rank_night
rank_week

Question: what is the rating when the rank (timeslot) is less than 3 and the rank (night) is less than 8?
SQL: SELECT SUM("rating") FROM tv_show_ratings_9 WHERE "rank_timeslot" < 3 AND "rank_night" < 8

Question: what is the rank (night) when the rating is more than 4.3 and the viewers (millions) is more than 10.72?
SQL: SELECT AVG("rank_night") FROM tv_show_ratings_9 WHERE "rating" > 4.3 AND "viewers_millions" > 10.72