github.com/unigraph-dev/dgraph@v1.1.1-0.20200923154953-8b52b426f765/systest/21million/queries/query-045 (about)

     1  {
     2    director(func: eq(name@en, "Steven Spielberg")) {
     3      name@en
     4      director.film {
     5        name@en
     6        numGenres : g as count(genre)
     7      }
     8      totalGenres : sum(val(g))
     9      genresPerMovie : avg(val(g))
    10    }
    11  }
    12  ---
    13  {
    14    "director": [
    15      {
    16        "name@en": "Steven Spielberg",
    17        "director.film": [
    18          {
    19            "name@en": "Twilight Zone: The Movie",
    20            "numGenres": 3
    21          },
    22          {
    23            "name@en": "Duel",
    24            "numGenres": 4
    25          },
    26          {
    27            "name@en": "Lincoln",
    28            "numGenres": 5
    29          },
    30          {
    31            "name@en": "Minority Report",
    32            "numGenres": 12
    33          },
    34          {
    35            "name@en": "Indiana Jones and the Temple of Doom",
    36            "numGenres": 4
    37          },
    38          {
    39            "name@en": "Schindler's List",
    40            "numGenres": 5
    41          },
    42          {
    43            "name@en": "Amistad",
    44            "numGenres": 3
    45          },
    46          {
    47            "name@en": "1941",
    48            "numGenres": 5
    49          },
    50          {
    51            "name@en": "Jaws",
    52            "numGenres": 8
    53          },
    54          {
    55            "name@en": "Indiana Jones and the Last Crusade",
    56            "numGenres": 4
    57          },
    58          {
    59            "name@en": "Saving Private Ryan",
    60            "numGenres": 3
    61          },
    62          {
    63            "name@en": "War Horse",
    64            "numGenres": 2
    65          },
    66          {
    67            "name@en": "Close Encounters of the Third Kind",
    68            "numGenres": 3
    69          },
    70          {
    71            "name@en": "Empire of the Sun",
    72            "numGenres": 7
    73          },
    74          {
    75            "name@en": "The Adventures of Tintin: The Secret of the Unicorn",
    76            "numGenres": 6
    77          },
    78          {
    79            "name@en": "Indiana Jones and the Kingdom of the Crystal Skull",
    80            "numGenres": 7
    81          },
    82          {
    83            "name@en": "Jurassic Park",
    84            "numGenres": 3
    85          },
    86          {
    87            "name@en": "The Lost World: Jurassic Park",
    88            "numGenres": 5
    89          },
    90          {
    91            "name@en": "Hook",
    92            "numGenres": 8
    93          },
    94          {
    95            "name@en": "The Color Purple",
    96            "numGenres": 1
    97          },
    98          {
    99            "name@en": "Slipstream",
   100            "numGenres": 1
   101          },
   102          {
   103            "name@en": "Indiana Jones and the Raiders of the Lost Ark",
   104            "numGenres": 2
   105          },
   106          {
   107            "name@en": "Munich",
   108            "numGenres": 5
   109          },
   110          {
   111            "name@en": "The Terminal",
   112            "numGenres": 5
   113          },
   114          {
   115            "name@en": "Catch Me If You Can",
   116            "numGenres": 4
   117          },
   118          {
   119            "name@en": "War of the Worlds",
   120            "numGenres": 9
   121          },
   122          {
   123            "name@en": "A.I. Artificial Intelligence",
   124            "numGenres": 4
   125          },
   126          {
   127            "name@en": "Bridge of Spies",
   128            "numGenres": 1
   129          },
   130          {
   131            "name@en": "The Sugarland Express",
   132            "numGenres": 3
   133          },
   134          {
   135            "name@en": "E.T. the Extra-Terrestrial",
   136            "numGenres": 5
   137          },
   138          {
   139            "name@en": "The BFG",
   140            "numGenres": 0
   141          },
   142          {
   143            "name@en": "Amblin",
   144            "numGenres": 1
   145          },
   146          {
   147            "name@en": "Something Evil",
   148            "numGenres": 3
   149          },
   150          {
   151            "name@en": "Savage",
   152            "numGenres": 2
   153          },
   154          {
   155            "name@en": "Always",
   156            "numGenres": 4
   157          },
   158          {
   159            "name@en": "Robopocalypse",
   160            "numGenres": 3
   161          },
   162          {
   163            "name@en": "The Attack of the Mummies",
   164            "numGenres": 0
   165          },
   166          {
   167            "name@en": "Firelight",
   168            "numGenres": 2
   169          },
   170          {
   171            "name@en": "Amazing Stories: Book One",
   172            "numGenres": 2
   173          }
   174        ],
   175        "totalGenres": 154,
   176        "genresPerMovie": 3.948718
   177      },
   178      {
   179        "name@en": "Steven Spielberg"
   180      },
   181      {
   182        "name@en": "Steven Spielberg"
   183      },
   184      {
   185        "name@en": "Steven Spielberg"
   186      }
   187    ]
   188  }