user: ### NOW ANSWER:
Question: what is the rating when the rank (timeslot) is less than 3 and the rank (night) is less than 8?
Columns: ['Episode', 'Rating', 'Share', 'Rating/Share (18-49)', 'Viewers (millions)', 'Rank (timeslot)', 'Rank (night)', 'Rank (week)']
Types: ['text', 'real', 'real', 'text', 'real', 'real', 'real', 'text']
Sample row: ['"Pilot"', 7.1, 12.0, '3.8/9', 10.72, 2.0, 8.0, '20']
SQL:

assistant: SELECT SUM("Rating") FROM "Table" WHERE "Rank (timeslot)" < 3.0 AND "Rank (night)" < 8.0;