User:Woodjr/Sandbox/Sparql2

States of the USA

{{#sparql:

 PREFIX dbpedia-resource: <http://dbpedia.org/resource/>
 PREFIX dbpedia-ontology: <http://dbpedia.org/ontology/>
 PREFIX dbpedia-property: <http://dbpedia.org/property/>
 PREFIX yago: <http://dbpedia.org/class/yago/>
 SELECT ?place_name AS ?Place MAX(?population) AS ?Population ?place_area AS ?Area
 WHERE {
   ?place a yago:StatesOfTheUnitedStates .
   ?place dbpedia-property:name ?place_name .
   ?place dbpedia-property:_2000pop ?population .
   ?place dbpedia-ontology:areaTotal ?place_area .
 }
 ORDER BY DESC(?Population)

|endpoint=http://dbpedia.org/sparql }}