example query on aggregates in SPARQL/Query Section 2

Just browsing over the example again and rethinking our discussion  
regarding implicit grouping...

PREFIX  <http://books.example/>
SELECT SUM(?lprice) AS ?totalPrice
WHERE {
   ?org :affiliates ?auth .
   ?auth :writesBook ?book .
   ?book :price ?lprice
}
GROUP BY ?org
HAVING (SUM(?lprice) > 10)


has ungrouped variables book, auth...Looking at our resolution, I  
honestly don't get my head around the semantics here:

"Consensus on prohibiting projecting variables/functions on variables  
that are not included in the group by clause. Details are pending  
discussion of ISSUE-41."

That doesn't seem to cover this case, where there are ungrouped  
variables that *don't* appear in projections or scalar functions.
Obviously, that query doesn't becomes weird if there are more than one  
authors from the same org, or if there are several prices for the same  
book.

Opinions to resolve?

best,
Axel

Received on Thursday, 5 November 2009 17:59:04 UTC