query_10.txt

Total price of the formalized contracts with the supplier MULTITEC

PREFIX pproc: <http://contsem.unizar.es/def/sector-publico/pproc#>
PREFIX s: <http://schema.org/>
PREFIX gr: <http://purl.org/goodrelations/v1#>
PREFIX pc: <http://purl.org/procurement/public-contracts#>
SELECT SUM(distinct ?currencyValue)
WHERE {
  ?uriCont a pproc:Contract ;
  pc:tender ?tender .
  ?tender pproc:formalizedDate ?formalizedDate ;
  pproc:supplier ?supplier ;
  pproc:offeredPrice ?offeredPrice .
  ?supplier s:name ?name .
  ?offeredPrice gr:hasCurrencyValue ?currencyValue ;
  gr:valueAddedTaxIncluded ?taxIncluded .
  FILTER ((?taxIncluded) AND regex(?name, "MULTITEC", "i"))
}