4,162
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→Most common programmatic areas for WMSE projects
| Line 61: | Line 61: | ||
==Most common programmatic areas for WMSE projects== | ==Most common programmatic areas for WMSE projects== | ||
<SPARQL tryit="1"> | <SPARQL tryit="1"> | ||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
#defaultView:BubbleChart | |||
SELECT ?program ?programLabel (COUNT(?item) AS ?count) | |||
WHERE | |||
{ | |||
?item wbt:P5 wb:Q2 . | |||
?item wbt:P14 wb:Q9. | |||
?item wbt:P10 ?program. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | |||
} | |||
GROUP BY ?program ?programLabel | |||
ORDER BY DESC(?count) | |||
</SPARQL> | </SPARQL> | ||