query-097edc25ecc890da05e3d94614b35d0d

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
    {
    # Find all production companies who have not produced an films in USA
    { # Find all production compnaies
    SELECT ?prodco
    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
    }
    }
    MINUS
    { # Find production companies that have produced at least 1 film with origin USA
    SELECT ?USAOriginprodco
    WHERE
    {
    ?art wdt:P272 ?USAOriginprodco. # get producers of the art
    ?art wdt:P31 wd:Q11424. # ensure that the art produced is an instance of film
    ?art wdt:P495 wd:Q30. # country of origin of the art is USA
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
    }
    # Now caluclate the net profits of the production companies
    ?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:P2142 ?boxOffice. # get the box office earnings for the film
    ?art wdt:P2130 ?cost. # Find the cost of each art
    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