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: Quais são os créditos de carbono totais obtidos e as despesas operacionais para projetos eólicos no Texas?
 ###Tabelas: 
CREATE TABLE EnergyPrices (fuel_type VARCHAR(255), year INT, price FLOAT); INSERT INTO EnergyPrices (fuel_type, year, price) VALUES ('Wind', 2020, 0.04); CREATE TABLE Projects (project_id INT, project_name VARCHAR(255), primary_fuel VARCHAR(255), location VARCHAR(255), installed_capacity INT, total_generation FLOAT, total_emissions INT); INSERT INTO Projects (project_id, project_name, primary_fuel, location, installed_capacity, total_generation, total_emissions) VALUES (2, 'Wind Farm A', 'Wind', 'Texas', 50000, 120000000, 20000); CREATE TABLE CarbonCredits (project_id INT, year INT, carbon_credits_earned INT); INSERT INTO CarbonCredits (project_id, year, carbon_credits_earned) VALUES (2, 2020, 15000); CREATE TABLE OperationalExpenses (project_id INT, year INT, operational_expenses FLOAT); INSERT INTO OperationalExpenses (project_id, year, operational_expenses) VALUES (2, 2020, 30000);
SELECT SUM(carbon_credits_earned) as total_carbon_credits, SUM(operational_expenses) as total_operational_expenses FROM CarbonCredits c JOIN Projects p ON c.project_id = p.project_id JOIN OperationalExpenses o ON c.project_id = o.project_id WHERE p.primary_fuel = 'Wind' AND p.location = 'Texas';