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

Question: What is the average share for episodes with over 7.82 viewers, ranks of 3 and a weekly rank of 54?
SQL: SELECT AVG("share") FROM elystone_episodes WHERE "viewers_millions" > 7.82 AND "rank_timeslot" = '3' AND "rank_week" = '54'

Question: What is the weekly rank for the episode with a share over 7 and a rating/share of 2.3/7?
SQL: SELECT "rank_week" FROM elystone_episodes WHERE "share" > 7 AND "rating_share_18_49" = '2.3/7'

Question: What is the weekly rank of the episode with more than 7.14mil viewers, a nightly rank of 5, and a rating/share of 2.9/10?
SQL: SELECT "rank_week" FROM elystone_episodes WHERE "viewers_millions" > 7.14 AND "rank_night" = '5' AND "rating_share_18_49" = '2.9/10'