Getting all transitive subtypes of a type through DBpedia SPARQL endpoint

To get all instances of a class (transitively):

## Inference Context Enabled ##
DEFINE input:inference "http://dbpedia.org/resource/inference/rules/dbpedia#"
SELECT COUNT(*)
WHERE {
  ?x a <http://dbpedia.org/ontology/NaturalPlace>
}

## Inference Context Enabled ##
DEFINE input:inference "http://dbpedia.org/resource/inference/rules/yago#"

SELECT COUNT(*)
WHERE {
  ?x a <http://dbpedia.org/class/yago/Award106696483>
}

Get all subclasses:

SELECT count(?x)

WHERE
  {
    {
      SELECT *
      WHERE
        {
          ?x rdfs:subClassOf ?y .
        }
    }  OPTION (transitive, t_distinct, t_in (?x), t_out (?y) ).
  FILTER (?y = <http://dbpedia.org/ontology/Person>)
}

Get all superclasses

SELECT ?y
WHERE
  {
    {
      SELECT *
      WHERE
        {
          ?x rdfs:subClassOf ?y .
        }
    }
    OPTION (TRANSITIVE, t_distinct, t_in (?x), t_out (?y) ) .
    FILTER (?x = <http://dbpedia.org/ontology/Cricketer>)
  }