Name the average rating % for shandong satellite tv and share % less than 1.74
CREATE TABLE table_name_13 (rating___percentage_ INTEGER, channel VARCHAR, share___percentage_ VARCHAR)
SELECT AVG(rating___percentage_) FROM table_name_13 WHERE channel = "shandong satellite tv" AND share___percentage_ < 1.74
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_13 (rating___percentage_ INTEGER, channel VARCHAR, share___percentage_ VARCHAR) Question: Name the average rating % for shandong satellite tv and share % less than 1.74 [/INST] SELECT AVG(rating___percentage_) FROM table_name_13 WHERE channel = "shandong satellite tv" AND share___percentage_ < 1.74 </s>