Table: tv_ratings_19
Columns: episode
18_49
viewers_m
rating
share

Question: What Viewers (m) has an Episode of school council?
SQL: SELECT AVG("viewers_m") FROM tv_ratings_19 WHERE "episode" = 'school council'

Question: What Viewers (m) has a Rating of 1.7, and an Episode of the game of life?
SQL: SELECT MAX("viewers_m") FROM tv_ratings_19 WHERE "rating" = '1.7' AND "episode" = 'the game of life'

Question: What Viewers (m) has an Episode of 40 days?
SQL: SELECT "viewers_m" FROM tv_ratings_19 WHERE "episode" = '40 days'

Question: What Episode has a Rating of 1.8, and Viewers (m) smaller than 2.73?
SQL: SELECT "episode" FROM tv_ratings_19 WHERE "rating" = '1.8' AND "viewers_m" < 2.73

Question: What Rating has Viewers (m) of 2.73?
SQL: SELECT "rating" FROM tv_ratings_19 WHERE "viewers_m" = 2.73

Question: What Episode has a Share of tba?
SQL: SELECT "episode" FROM tv_ratings_19 WHERE "share" = 'tba'