true prefix oplsioc: prefix sioc: prefix foaf: select (sum(?li+>tpch:lineextendedprice) / 7.0) as ?avg_yearly from where { ?li a tpch:lineitem ; tpch:has_part ?part . ?part tpch:container "MED BOX" ; tpch:brand "Brand#23" . { select ?part, (0.2 * avg(?li2+>tpch:linequantity)) as ?threshold where { ?li2 a tpch:lineitem ; tpch:has_part ?part } } filter (?li+>tpch:linequantity < ?threshold) } ]]>http://demo.openlinksw.com/tpchsoft/sparql