Table: howie_ep_data
Columns: episode_number
episode
rating
share
rating_share_18_49
viewers_millions
rank_overall

Question: WHAT IS THE RATING THAT HAD A SHARE SMALLER THAN 4, AND 2.47 MILLION VIEWERS?
SQL: SELECT COUNT("rating") FROM howie_ep_data WHERE "share" < 4 AND "viewers_millions" > 2.47

Question: WHAT IS THE NUMBER OF VIEWERS WITH EPISODE LARGER THAN 10, RATING SMALLER THAN 2?
SQL: SELECT MAX("viewers_millions") FROM howie_ep_data WHERE "episode_number" > 10 AND "rating" < 2

Question: WHAT IS THE HIGHEST VIEWERS WITH AN EPISODE LESS THAN 15 AND SHARE LAGER THAN 7?
SQL: SELECT MAX("viewers_millions") FROM howie_ep_data WHERE "episode_number" < 15 AND "share" > 7