Table: new_amsterdam_ratings
Columns: episode
air_date
rating
share
rating_share_18_49
viewers_m
timeslot_rank
night_rank
overall_rank

Question: What is the overall rank with rating smaller than 8.2 and rating share of 4.5/11?
SQL: SELECT COUNT("overall_rank") FROM new_amsterdam_ratings WHERE "rating_share_18_49" = '4.5/11' AND "rating" < 8.2

Question: What is the rating for the episode with the night rank of 11 and timeslot rank is larger than 4?
SQL: SELECT AVG("rating") FROM new_amsterdam_ratings WHERE "night_rank" = '11' AND "timeslot_rank" > 4

Question: What is the smallest share for a timeslot ranking less than 4 and fewer viewers than 8.78 million?
SQL: SELECT MIN("share") FROM new_amsterdam_ratings WHERE "viewers_m" < 8.78 AND "timeslot_rank" < 4

Question: What is the rating of the episode with 13.47 million viewers and overall rank larger than 6?
SQL: SELECT SUM("rating") FROM new_amsterdam_ratings WHERE "viewers_m" = 13.47 AND "overall_rank" > 6

Question: What is the rank of the episode with a share of 6 and timeslot rank smaller than 4?
SQL: SELECT AVG("overall_rank") FROM new_amsterdam_ratings WHERE "share" = 6 AND "timeslot_rank" < 4