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 países tiveram mais contratos de defesa concedidos a empresas de propriedade de mulheres nos últimos 6 meses?
 ###Tabelas: 
CREATE TABLE defense_contracts (id INT, contract_date DATE, contract_value FLOAT, business_id INT, business_owner_gender VARCHAR(255), business_location VARCHAR(255)); INSERT INTO defense_contracts (id, contract_date, contract_value, business_id, business_owner_gender, business_location) VALUES (1, '2022-01-01', 10000, 1, 'Female', 'United States'); INSERT INTO defense_contracts (id, contract_date, contract_value, business_id, business_owner_gender, business_location) VALUES (2, '2022-02-15', 5000, 1, 'Female', 'Canada'); INSERT INTO defense_contracts (id, contract_date, contract_value, business_id, business_owner_gender, business_location) VALUES (3, '2022-03-01', 20000, 2, 'Male', 'United Kingdom');
SELECT business_location, COUNT(*) as num_contracts FROM defense_contracts WHERE business_owner_gender = 'Female' AND contract_date >= DATEADD(month, -6, GETDATE()) GROUP BY business_location ORDER BY num_contracts DESC;