reteplayground
Animation

πŸ“Š Each couple β€” the numbers + the dance

CoupleSkillMoves+3
Pair 3, song 1, take 1 @enBeginner @en70…
Pair 1, song 1, take 1 @enBeginner @en86…
Pair 2, song 1, take 1 @enIntermediate @en93…
Pair 4, song 1, take 1 @enIntermediate @en74…
Run this query β†’ no server Β· no download Β· no account
caviri.github.io/rete
Run this query in the playground β†’ 5 rows Β· 350 ms Β· no server, no download β€” the query runs in your browser.

The query

PREFIX dance: <https://w3id.org/rete/dance#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?couple ?skill (COUNT(?seg) AS ?moves) (ROUND(AVG(?hcf)*1000)/1000 AS ?handContact) (ROUND(AVG(?sep)*100)/100 AS ?separation_m) ?animation WHERE { ?perf dance:animation ?animation ; rdfs:label ?couple ; dance:hasLeader/dance:hasSkillLevel/rdfs:label ?skill ; dance:hasSegment ?seg . ?seg dance:handContactFraction ?hcf ; dance:meanCoupleSeparation ?sep . } GROUP BY ?perf ?couple ?skill ?animation ORDER BY DESC(?handContact)

rete playground Β· documentation Β· github.com/caviri/rete