true prefix oplsioc: prefix sioc: prefix foaf: select ?li+>tpch:shipmode, sum ( bif:__or ( bif:equ (?ord+>tpch:orderpriority, "1-URGENT"), bif:equ (?ord+>tpch:orderpriority, "2-HIGH") ) ) as ?high_line_count, sum (1 - bif:__or ( bif:equ (?ord+>tpch:orderpriority, "1-URGENT"), bif:equ (?ord+>tpch:orderpriority, "2-HIGH") ) ) as ?low_line_count from where { ?li tpch:has_order ?ord . filter (?li+>tpch:shipmode in ("MAIL", "SHIP") && (?li+>tpch:commitdate < ?li+>tpch:receiptdate) && (?li+>tpch:shipdate < ?li+>tpch:commitdate) && (?li+>tpch:receiptdate >= "1994-01-01"^^xsd:date) && (?li+>tpch:receiptdate < bif:dateadd ("year", 1, "1994-01-01"^^xsd:date)) ) } order by ?li+>tpch:shipmode ]]>http://demo.openlinksw.com/tpchsoft/sparql