Query for retrieving country wise sales report from Magento Database

coutrywise_report.sql

SET @fromDate = DATE_SUB(NOW(), INTERVAL 1 YEAR);
SELECT country_id, count(*) as total_orders,SUM(s.grand_total) 
FROM `sales_flat_order_address` a
INNER JOIN sales_flat_order s ON s.entity_id = a.parent_id
WHERE s.created_at >= @fromDate
AND a.address_type = 'shipping'
GROUP BY country_id
ORDER BY total_orders DESC