Bradley L. Foley

Here is a simple query you can run against your transactions database to get some useful information about your international orders.

Select SUM(subtotal) as total, CountryCode, CountryName
From
(
Select Distinct TrackingNumber, Subtotal, CountryCode, CountryName
From (
SELECT     PurchaseOrders.SubTotal, PurchaseOrders.TrackingNumber, OrderAddresses.CountryCode, OrderAddresses.CountryName
FROM         PurchaseOrders LEFT OUTER JOIN
                      Shipments ON PurchaseOrders.OrderGroupId = Shipments.OrderGroupId LEFT OUTER JOIN
                      OrderAddresses ON Shipments.ShippingAddressId = OrderAddresses.OrderAddressId
                      Where OrderAddresses.CountryCode <> 'US'                      Â
                      ) a
                      ) b
                      group by CountryCode, CountryName
                      order by total desc

It will provide a good executive level overview.