## Sales by Country

PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT ?salesRep ?has_company ?scountry ?orderValue ?month ?quarter ?year ?financialYear

WHERE 
  {
    ?ord a ecrm:Order.
    OPTIONAL{?ord ecrm:has_ecrm_organization ?org }.
    OPTIONAL{?ord ecrm:has_company ?has_company}.
    OPTIONAL{?ord ecrm:companyName ?company }.
    OPTIONAL{?ord ecrm:has_contact ?has_contact}.
    OPTIONAL{?ord ecrm:contactName ?contact}.
    OPTIONAL{?ord ecrm:orderNo ?orderNo}.
    OPTIONAL{?ord ecrm:shipFirstName ?sfname}.
    OPTIONAL{?ord ecrm:shipSecondName ?ssname}.
    OPTIONAL{?ord ecrm:phoneNumber ?phoneNumber}.
    OPTIONAL{?ord ecrm:phoneExtension ?phoneExtension}.
    OPTIONAL{?ord ecrm:email ?email}.
    OPTIONAL{?ord ecrm:shipCountry ?scountry }.
    OPTIONAL{?ord ecrm:shipProvince ?sprovince}.
    OPTIONAL{?ord ecrm:shipCity ?scity}.
    OPTIONAL{?ord ecrm:shipPostalCode ?spcode}.
    OPTIONAL{?ord ecrm:dbpedia_shipCity ?dbpedia_shipCity}.
    OPTIONAL{?ord ecrm:shipAddress1 ?shipAddress1}.
    OPTIONAL{?ord ecrm:shipAddress2 ?shipAddress2}.
    OPTIONAL{?ord ecrm:salesRep ?salesRep}.
    OPTIONAL{?ord ecrm:orderDate ?orderDate}.
    OPTIONAL{?ord ecrm:orderValue ?orderValue}.
    OPTIONAL{?ord ecrm:refund ?refund}.
    OPTIONAL{?ord ecrm:year ?year}.
    OPTIONAL{?ord ecrm:month ?month}.
    OPTIONAL{?ord ecrm:quarter ?quarter}.
    OPTIONAL{?ord ecrm:financialYear ?financialYear}.
  }

order by desc 7 5 1