Table: harper_island_ratings
Columns: episode
us_air_date
rating
share
rating_share_18_49
viewers_millions

Question: What is the lowest numbered episode that had a rating/share of 0.9/4 and more than 3.79 million viewers?
SQL: SELECT MIN("episode") FROM harper_island_ratings WHERE "rating_share_18_49" = '0.9/4' AND "viewers_millions" > 3.79

Question: What is the average number of million viewers that watched an episode before episode 11 with a share of 4?
SQL: SELECT AVG("viewers_millions") FROM harper_island_ratings WHERE "episode" < 11 AND "share" = '4'

Question: What is the rating/share for episode 13?
SQL: SELECT "rating_share_18_49" FROM harper_island_ratings WHERE "episode" = 13

Question: What is the lowest number of million viewers for an episode before episode 5 with a rating/share of 1.1/3?
SQL: SELECT MIN("viewers_millions") FROM harper_island_ratings WHERE "rating_share_18_49" = '1.1/3' AND "episode" < 5