What is the average share for episodes with over 7.82 viewers, ranks of 3 and a weekly rank of 54?
CREATE TABLE table_name_56 (share INTEGER, rank__week_ VARCHAR, viewers__millions_ VARCHAR, rank__timeslot_ VARCHAR)
SELECT AVG(share) FROM table_name_56 WHERE viewers__millions_ > 7.82 AND rank__timeslot_ = "3" AND rank__week_ = "54"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (share INTEGER, rank__week_ VARCHAR, viewers__millions_ VARCHAR, rank__timeslot_ VARCHAR) Question: What is the average share for episodes with over 7.82 viewers, ranks of 3 and a weekly rank of 54? [/INST] SELECT AVG(share) FROM table_name_56 WHERE viewers__millions_ > 7.82 AND rank__timeslot_ = "3" AND rank__week_ = "54" </s>