CREATE TABLE table_42877 ("Episode" CLOB, "Rating" FLOAT, "Share" FLOAT, "Rating/Share  ( 18-49 ) " CLOB, "Viewers  ( millions ) " FLOAT, "Rank  ( Timeslot ) " CLOB, "Rank  ( Night ) " CLOB, "Rank  ( Week ) " CLOB)

What is the average share for episodes with over 7.82 viewers, ranks of 3 and a weekly rank of 54?
SELECT AVG("Share") FROM table_42877 WHERE "Viewers (millions)" > '7.82' AND "Rank (Timeslot)" = '3' AND "Rank (Week)" = '54'
SELECT AVG("Share") FROM "table_42877" WHERE "Rank (Timeslot)" = '3' AND "Rank (Week)" = '54' AND "Viewers (millions)" > '7.82'