Table: oprahs_big_give_ratings
Columns: air_date
timeslot_est
season
rating
share
18_49_rating_share
viewers_m
weekly_rank

Question: What is the weekly rank for a share of 9 and 9.42 million viewers?
SQL: SELECT "weekly_rank" FROM oprahs_big_give_ratings WHERE "share" = 9 AND "viewers_m" = 9.42

Question: What is the sum of all ratings at a weekly rank of 10 and a share less than 11?
SQL: SELECT SUM("rating") FROM oprahs_big_give_ratings WHERE "weekly_rank" = '10' AND "share" < 11

Question: What is the highest number of viewers for a rating greater than 9.4?
SQL: SELECT MAX("viewers_m") FROM oprahs_big_give_ratings WHERE "rating" > 9.4

Question: What is the rating/share with more than 8.88 million viewers and a weekly rant of 27?
SQL: SELECT "18_49_rating_share" FROM oprahs_big_give_ratings WHERE "viewers_m" > 8.88 AND "weekly_rank" = '27'