Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é a média do painel administrativo quando o painel cultural e educacional é maior que 1 e o painel industrial e comercial é menor que 4?
 ###Tabelas: CREATE TABLE nba_finals (nba_finals_id AUTO_INCREMENT PRIMARY KEY, Game VARCHAR, Date VARCHAR, Home Team VARCHAR, Result VARCHAR, Road Team VARCHAR) CREATE TABLE main_sports_clubs (main_sports_clubs_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Leagues VARCHAR, Venue VARCHAR, Location VARCHAR, Capacity INT, Established INT) CREATE TABLE semi-final_2 (semi-final_2_id AUTO_INCREMENT PRIMARY KEY, Draw INT, Artist VARCHAR, Song VARCHAR, Jury votes INT, Televotes INT, Total votes INT, Result VARCHAR) CREATE TABLE composition_of_the_17th_seanad (composition_of_the_17th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE oldham (oldham_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Location VARCHAR, Type VARCHAR, Completed VARCHAR, List entry number INT)  
SELECT AVG Administrative Panel FROM composition_of_the_17th_seanad WHERE Cultural and Educational Panel > 1 AND Industrial and Commercial Panel < 4