true
prefix oplsioc:
prefix sioc:
prefix foaf:
select ?supp_nation ?cust_nation ?li_year
sum (?value) as ?revenue
from
where {
{
select
?suppn+>tpch:name as ?supp_nation,
?custn+>tpch:name as ?cust_nation,
(bif:year (?li+>tpch:shipdate)) as ?li_year,
(?li+>tpch:lineextendedprice * (1 - ?li+>tpch:linediscount)) as ?value
where {
?li a tpch:lineitem ; tpch:has_order ?ord ; tpch:has_supplier ?supp .
?ord tpch:has_customer ?cust .
?cust tpch:has_nation ?custn .
?supp tpch:has_nation ?suppn .
filter ((
(?custn+>tpch:name = "http://dbpedia.org/resource/France"
and ?suppn+>tpch:name = "http://dbpedia.org/resource/Germany") ||
(?custn+>tpch:name = "http://dbpedia.org/resource/Germany"
and ?suppn+>tpch:name = "http://dbpedia.org/resource/France") ) &&
(?li+>tpch:shipdate >= "1995-01-01"^^xsd:date) &&
(?li+>tpch:shipdate <= "1996-12-31"^^xsd:date) ) } } }
order by
?supp_nation
?li_year
]]>http://demo.openlinksw.com/tpchsoft/sparql