query-46dfb1d3b4a942e29391912900e8c940

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?institution (MIN(?total) AS ?_) (COUNT(*) AS ?row_number)
 {
   {SELECT * {  {
  SELECT ?institution  (COUNT(?item) AS ?total) {
    ?item wdt:P485 ?institution .
    OPTIONAL {?institution wdt:P17 ?pays .}
  }
  GROUP BY ?institution HAVING (?total > 20) 
}} }
   {SELECT (?institution AS ?institution_) (?total AS ?total_) {  {
  SELECT ?institution  (COUNT(?item) AS ?total) {
    ?item wdt:P485 ?institution .
    OPTIONAL {?institution wdt:P17 ?pays .}
  }
  GROUP BY ?institution HAVING (?total > 20) 
}} }
    FILTER (?total < ?total_  || ?total = ?total_  && str(?institution) <= str(?institution_) )
} GROUP BY ?institution ORDER BY ?row_number

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?_") v4("?institution"):::projected v8("?institution_") v6("?item") v7("?pays") v9("?row_number") v8("?total"):::projected v8("?total_") f0[["(?total < ?total_ || ?total = ?total_str(?institution) <= str(?institution_))"]] f0 --> v8 f0 --> v8 f0 --> v4 f0 --> v8 f1[["?total > '20^^xsd:integer'"]] f1 --> v8 v6 --"wdt:P485"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P17".-> v7 end bind3[/"count(?item)"/] v6 --o bind3 bind3 --as--o v8 f4[["?total > '20^^xsd:integer'"]] f4 --> v8 v6 --"wdt:P485"--> v4 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P17".-> v7 end bind6[/"count(?item)"/] v6 --o bind6 bind6 --as--o v8 bind7[/"?institution"/] v4 --o bind7 bind7 --as--o v8 bind8[/"?total"/] v8 --o bind8 bind8 --as--o v8 bind11[/"min(?total)"/] v8 --o bind11 bind11 --as--o v8 bind12[/"count(*)"/] bind12 --as--o v9