What is the administrative panel average when the cultural and educational panel is greater than 1 and the industrial and commercial panel less than 4?
CREATE TABLE table_name_77 (administrative_panel INTEGER, cultural_and_educational_panel VARCHAR, industrial_and_commercial_panel VARCHAR)
SELECT AVG(administrative_panel) FROM table_name_77 WHERE cultural_and_educational_panel > 1 AND industrial_and_commercial_panel < 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_77 (administrative_panel INTEGER, cultural_and_educational_panel VARCHAR, industrial_and_commercial_panel VARCHAR) Question: What is the administrative panel average when the cultural and educational panel is greater than 1 and the industrial and commercial panel less than 4? [/INST] SELECT AVG(administrative_panel) FROM table_name_77 WHERE cultural_and_educational_panel > 1 AND industrial_and_commercial_panel < 4 </s>