Table: tv_show_ratings_11
Columns: order
episode
rating
share
rating_share_18_49
viewers_millions
rank_night
rank_timeslot
rank_week

Question: What is the sum of share with a rating larger than 1.2, a 3 rank timeslot, and 6.07 million viewers?
SQL: SELECT SUM("share") FROM tv_show_ratings_11 WHERE "rating" > 1.2 AND "rank_timeslot" = 3 AND "viewers_millions" = 6.07

Question: What is the average week rank with 1.2 ratings, less than 1.94 million viewers, and a night rank less than 11?
SQL: SELECT AVG("rank_week") FROM tv_show_ratings_11 WHERE "rating" = 1.2 AND "viewers_millions" < 1.94 AND "rank_night" < 11