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: Error code: 429 - {'error': {'message': 'You exceeded your current quota, please check your plan and billing details. For more information on this error, read the docs: https://platform.openai.com/docs/guides/error-codes/api-errors.', 'type': 'insufficient_quota', 'param': None, 'code': 'insufficient_quota'}}
 ###Tabelas: 
CREATE TABLE faculty (id INT, name VARCHAR(50), department VARCHAR(50), position VARCHAR(50)); INSERT INTO faculty (id, name, department, position) VALUES (1, 'Gina Wilson', 'Humanities', 'Professor'); INSERT INTO faculty (id, name, department, position) VALUES (2, 'Harry Moore', 'Humanities', 'Assistant Professor'); CREATE TABLE publications (id INT, faculty_id INT, title VARCHAR(100)); INSERT INTO publications (id, faculty_id, title) VALUES (1, 1, 'Publication A'); INSERT INTO publications (id, faculty_id, title) VALUES (2, 1, 'Publication B'); INSERT INTO publications (id, faculty_id, title) VALUES (3, 2, 'Publication C');
SELECT AVG(num_publications) FROM (SELECT f.id, COUNT(p.id) as num_publications FROM faculty f LEFT JOIN publications p ON f.id = p.faculty_id WHERE f.department = 'Humanities' GROUP BY f.id) t;