<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="/isparql/xslt/dynamic-page.xsl"?><iSPARQL xmlns="urn:schemas-openlink-com:isparql"><ISparqlDynamicPage><proxy>true</proxy><query><![CDATA[#service:/sparql
#should-sponge:soft

define sql:signal-void-variables 1
prefix tpch: <http://www.openlinksw.com/schemas/tpch#>
prefix oplsioc: <http://www.openlinksw.com/schemas/oplsioc#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
select
  ?o_year,
  (?sum1 / ?sum2) as ?mkt_share
from <http://demo.openlinksw.com/tpch>
where {
    { select
        ?o_year
        sum (?volume * bif:equ (?nation, "http://dbpedia.org/resource/Brazil")) as ?sum1
        sum (?volume) as ?sum2
      where {
          { select
              (bif:year (?ord+>tpch:orderdate)) as ?o_year,
              (?li+>tpch:lineextendedprice * (1 - ?li+>tpch:linediscount)) as ?volume,
              ?n2+>tpch:name as ?nation
            where {
                ?li a tpch:lineitem ; tpch:has_order ?ord ; tpch:has_part ?part .
                ?li+>tpch:has_supplier tpch:has_nation ?n2 .
                ?order+>tpch:has_customer+>tpch:has_nation+>tpch:has_region tpch:name "http://dbpedia.org/resource/America" .
                ?part tpch:type "ECONOMY ANODIZED STEEL" .
                filter ((?ord+>tpch:orderdate >= "1995-01-01"^^xsd:date) &&
                  (?ord+>tpch:orderdate <= "1996-12-31"^^xsd:date) ) } } } } }
order by
  ?o_year
]]></query><graph>http://demo.openlinksw.com/tpch</graph></ISparqlDynamicPage><should_sponge>soft</should_sponge><service>/sparql</service></iSPARQL>