query-66012196e489c8fa3d907272991f423e

rq turtle/ttl

TODO

Use at

• https://query.wikidata.org/sparql

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#>
SELECT ?prodco ?prodcoLabel (SUM(?boxOffice - ?cost) as ?totalNetProfit)
    WHERE
    {
    ?art wdt:P272 ?prodco. # art produced by production companies
    ?art wdt:P31 wd:Q11424. # ensure that the art produced is an instance of film
    ?art wdt:P495 ?countryOfOrigin. # counbtry of origin of the art
    ?art wdt:P2142 ?boxOffice. # get the box office earnings for the fil
    ?art wdt:P2130 ?cost. # Find the cost of each art
    #Does this make sure all companies that didn't produce ANY film in USA are removed?
    FILTER (?countryOfOrigin != wd:Q30) # Ensure that the film does not originate from USA.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
    GROUP BY ?prodco ?prodcoLabel
    ORDER BY desc(?totalNetProfit)
    LIMIT 20

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/03