Magento country wise annual sales report directly from the database – List Of What

There are many extensions out there which you can use to get country wise sales reports. However, you can retrieve much more things if you be little familiar with SQL queries. You can use below queries to get annual sales figures based on countries. 
*Please note that the order values displayed are the subtotals before taxes.Detailed Report

SELECT orders.increment_id as id, orders.state, addresses.firstname, addresses.lastname, addresses.country_id, orders.subtotal as subtotal, orders.created_atFROM sales_flat_order AS ordersJOIN sales_flat_order_address AS addressesON addresses.parent_id=orders.entity_idWHERE relation_child_real_id IS NULLAND addresses.address_type=’shipping’

AND YEAR(orders.created_at) = YEAR(CURDATE())