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: Calcular o montante total de empréstimos socialmente responsáveis emitidos para empresas de propriedade de mulheres na Ásia por ano.
 ###Tabelas: 
CREATE TABLE loans (id INT PRIMARY KEY, bank_id INT, product VARCHAR(255), mohafiza_rate DECIMAL(5,2), issue_date DATE, is_socially_responsible BOOLEAN, is_women_owned_business BOOLEAN); CREATE TABLE regions (id INT PRIMARY KEY, name VARCHAR(255), country VARCHAR(255)); CREATE VIEW loan_views AS SELECT loans.id, loans.bank_id, loans.product, loans.mohafiza_rate, loans.issue_date, loans.is_socially_responsible, loans.is_women_owned_business, regions.country FROM loans INNER JOIN regions ON TRUE; CREATE VIEW yearly_loan_views AS SELECT DATE_PART('year', loan_views.issue_date) AS year, loan_views.mohafiza_rate, loan_views.is_socially_responsible, loan_views.is_women_owned_business FROM loan_views;
SELECT yearly_loan_views.year, SUM(yearly_loan_views.mohafiza_rate) AS total_amount FROM yearly_loan_views WHERE yearly_loan_views.is_socially_responsible = TRUE AND yearly_loan_views.is_women_owned_business = TRUE AND regions.country = 'Asia' GROUP BY yearly_loan_views.year;