42_Select_the_average_number_of_citation_of_reactions_that_have_at_least_one_citation

rq turtle/ttl

Select the average number of citation of reactions that have at least one citation

Use at

• https://sparql.rhea-db.org/sparql

PREFIX rh: <http://rdf.rhea-db.org/>
SELECT
  (AVG(?linksToPubmedPerReaction) AS ?avgLinksToPubmedPerReaction)
WHERE
{
  SELECT
    ?reaction
    (COUNT(DISTINCT ?citation) AS ?linksToPubmedPerReaction)
  WHERE
  {
    ?reaction rh:citation ?citation .
  }
GROUP BY ?reaction ORDER BY DESC(?linksToPubmedPerReaction)
}

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?avgLinksToPubmedPerReaction")
  v3("?citation")
  v4("?linksToPubmedPerReaction"):::projected 
  v2("?reaction")
  v2 --"rh:citation"-->  v3
  bind1[/"count(?citation)"/]
  v3 --o bind1
  bind1 --as--o v4
  bind3[/"average(?linksToPubmedPerReaction)"/]
  v4 --o bind3
  bind3 --as--o v4