Table: tv_ratings_4
Columns: col
air_date
timeslot
rating
share
18_49
viewers
weekly_rank

Question: What is the total number of viewers where the share is 7 and the week rank is 64?
SQL: SELECT COUNT("viewers") FROM tv_ratings_4 WHERE "share" = 7 AND "weekly_rank" = '64'

Question: How many episodes have a share bigger than 7.0?
SQL: SELECT COUNT("col") FROM tv_ratings_4 WHERE "share" > 7.0

Question: How many episodes have a weekly rank tba and are broadcast at 8:00 p.m.?
SQL: SELECT COUNT("col") FROM tv_ratings_4 WHERE "weekly_rank" = 'TBA' AND "timeslot" = '8:00 P.M.'

Question: What are the timeslot(s) for broadcast on February 22, 2008?
SQL: SELECT "timeslot" FROM tv_ratings_4 WHERE "air_date" = 'February 22, 2008'

Question: What broadcast dates have a weekly rank of 73?
SQL: SELECT COUNT("air_date") FROM tv_ratings_4 WHERE "weekly_rank" = '73'