What is the timeslor rank for the episode with larger than 2.9 rating, rating/share of 2.6/8 and rank for the night higher than 5?
CREATE TABLE table_name_2 (rank__timeslot_ INTEGER, rank__night_ VARCHAR, rating VARCHAR)
SELECT AVG(rank__timeslot_) FROM table_name_2 WHERE rating > 2.9 AND rating / NULLIF(SHARE(18 - 49), 0) = 2.6 / NULLIF(8, 0) AND rank__night_ > 5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (rank__timeslot_ INTEGER, rank__night_ VARCHAR, rating VARCHAR) Question: What is the timeslor rank for the episode with larger than 2.9 rating, rating/share of 2.6/8 and rank for the night higher than 5? [/INST] SELECT AVG(rank__timeslot_) FROM table_name_2 WHERE rating > 2.9 AND rating / NULLIF(SHARE(18 - 49), 0) = 2.6 / NULLIF(8, 0) AND rank__night_ > 5 </s>