human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: 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?
gpt
SELECT COUNT Rating FROM table WHERE Share < 4 AND Viewers (millions) > 2.47