user: ### NOW ANSWER:
Question: WHAT IS THE RATING THAT HAD A SHARE SMALLER THAN 4, AND 2.47 MILLION VIEWERS?
Columns: ['Episode number', 'Episode', 'Rating', 'Share', 'Rating/Share (18-49)', 'Viewers (millions)', 'Rank (Overall)']
Types: ['real', 'text', 'real', 'real', 'text', 'real', 'text']
Sample row: [1.0, '"Pilot/102"', 4.7, 7.0, '2.1/7', 7.68, '66']
SQL:

assistant: SELECT COUNT("Rating") FROM "Table" WHERE "Share" < 4.0 AND "Viewers (millions)" > 2.47;