How many {production designer} are to/by {Georges Méliès} ?
How many movies has Georges Melies production designed?
How many movies have Georges Méliès as the production designer?
SELECT ( COUNT ( ?j ) AS ?v ) { ?j property:production_designer resource:Georges_Méliès }
SELECT (COUNT(?sub) AS ?subs ) {
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> ?sub .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P2554> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> http://wikidata.dbpedia.org/resource/Q152272 .
} 

SELECT (COUNT(?sub) AS ?value ) { ?sub wdt:P2554 wd:Q152272 }
5