CREATE TABLE table_name_70 (rating VARCHAR2, share VARCHAR2, viewers__millions_ VARCHAR2)

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