true prefix oplsioc: prefix sioc: prefix foaf: select ?supp+>tpch:has_nation+>tpch:name as ?nation, sum(?li+>tpch:lineextendedprice * (1 - ?li+>tpch:linediscount)) as ?revenue from where { ?li a tpch:lineitem ; tpch:has_order ?ord ; tpch:has_supplier ?supp . ?ord tpch:has_customer ?cust . ?supp+>tpch:has_nation+>tpch:has_region tpch:name "http://dbpedia.org/resource/Asia" . filter ((?cust+>tpch:has_nation = ?supp+>tpch:has_nation) && (?ord+>tpch:orderdate >= "1994-01-01"^^xsd:date) && (?ord+>tpch:orderdate < bif:dateadd ("year", 1,"1994-01-01" ^^xsd:date)) ) } order by desc (sum(?li+>tpch:lineextendedprice * (1 - ?li+>tpch:linediscount))) ]]>http://demo.openlinksw.com/tpchsoft/sparql