sparql_golfing.txt

select ?prop ?l ?measure ?bp ?bn
where
{
  filter(?measure=max(?measure))
  {
select (count(distinct ?s) as ?bp) (count(distinct ?t) as ?bn) (?bp/(?bn+0.01) as ?measure) ?prop ?l
where
{
  
  {
    ?s <http://purl.org/dc/terms/subject> <http://dbpedia.org/resource/Category:Capitals_in_Europe>.
  ?s ?prop ?xl.
    values ?s { <http://dbpedia.org/resource/Warsaw> <http://dbpedia.org/resource/Berlin> <http://dbpedia.org/resource/Bucharest> <http://dbpedia.org/resource/Budapest> <http://dbpedia.org/resource/Andorra_la_Vella> <http://dbpedia.org/resource/Athens> <http://dbpedia.org/resource/Paris> <http://dbpedia.org/resource/Amsterdam> <http://dbpedia.org/resource/Belgrade> <http://dbpedia.org/resource/Bratislava> <http://dbpedia.org/resource/Brussels>}
    }
  union
  {
    ?t <http://purl.org/dc/terms/subject> <http://dbpedia.org/resource/Category:Capitals_in_Europe>.
    ?t ?prop ?xl.
    values ?t {<http://dbpedia.org/resource/New_York_City> <http://dbpedia.org/resource/Maputo> <http://dbpedia.org/resource/Quebec_City> <http://dbpedia.org/resource/Brest,_Belarus> <http://dbpedia.org/resource/Auckland> <http://dbpedia.org/resource/Bonn> <http://dbpedia.org/resource/Chur> <http://dbpedia.org/resource/Cologne> <http://dbpedia.org/resource/Fleetwood> <http://dbpedia.org/resource/Ghazni> <http://dbpedia.org/resource/Europe> <http://dbpedia.org/resource/Romania> <http://dbpedia.org/resource/Gothenburg> <http://dbpedia.org/resource/Hamburg> <http://dbpedia.org/resource/Ankara> <http://dbpedia.org/resource/Baku> <http://dbpedia.org/resource/Belfast> <http://dbpedia.org/resource/Bern> <http://dbpedia.org/resource/Cardiff>                                                   }
    }
  filter(?xl<=?l)
  {
select distinct ?prop ?l
where
{
  ?s <http://purl.org/dc/terms/subject> <http://dbpedia.org/resource/Category:Capitals_in_Europe>.
   ?s ?prop ?l.
  values ?s { <http://dbpedia.org/resource/Warsaw> <http://dbpedia.org/resource/Berlin> <http://dbpedia.org/resource/Bucharest> <http://dbpedia.org/resource/Budapest> <http://dbpedia.org/resource/Andorra_la_Vella> <http://dbpedia.org/resource/Athens> <http://dbpedia.org/resource/Paris> <http://dbpedia.org/resource/Amsterdam> <http://dbpedia.org/resource/Belgrade> <http://dbpedia.org/resource/Bratislava> <http://dbpedia.org/resource/Brussels>
<http://dbpedia.org/resource/New_York_City> <http://dbpedia.org/resource/Maputo> <http://dbpedia.org/resource/Quebec_City> <http://dbpedia.org/resource/Brest,_Belarus> <http://dbpedia.org/resource/Auckland> <http://dbpedia.org/resource/Bonn> <http://dbpedia.org/resource/Chur> <http://dbpedia.org/resource/Cologne> <http://dbpedia.org/resource/Fleetwood> <http://dbpedia.org/resource/Ghazni> <http://dbpedia.org/resource/Europe> <http://dbpedia.org/resource/Romania> <http://dbpedia.org/resource/Gothenburg> <http://dbpedia.org/resource/Hamburg> <http://dbpedia.org/resource/Ankara> <http://dbpedia.org/resource/Baku> <http://dbpedia.org/resource/Belfast> <http://dbpedia.org/resource/Bern> <http://dbpedia.org/resource/Cardiff>                                                   
  }
         filter(isLiteral(?l))
}
order by ?l
         }
  }
         group by ?prop ?l
}
}
order by desc(?measure)