query-59e4a989f1fe65d985fee2d405678999

rq turtle/ttl

stock-listed US companies with founders who (or whose parents) were born outside the US SELECT ?companyLabel (GROUP_CONCAT(DISTINCT ?founderLabel; separator=", ") AS ?founders) WHERE { ?company wdt:P112 ?founder; wdt:P17 wd:Q30. FILTER EXISTS { ?company wdt:P414|wdt:P249 []. } ?founder (wdt:P22|wdt:P2137|wdt:P2139|wdt:P2226|wdt:P2295 ?money. } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } GROUP BY ?companyLabel ORDER BY DESC(MAX(?money)) ?companyLabel

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# stock-listed US companies with founders who (or whose parents) were born outside the US
SELECT ?companyLabel (GROUP_CONCAT(DISTINCT ?founderLabel; separator=", ") AS ?founders) WHERE {
  ?company wdt:P112 ?founder;
           wdt:P17 wd:Q30.
  FILTER EXISTS { ?company wdt:P414|wdt:P249 []. }
  ?founder (wdt:P22|wdt:P2137|wdt:P2139|wdt:P2226|wdt:P2295 ?money. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?companyLabel
ORDER BY DESC(MAX(?money)) ?companyLabel

Query found at