SelectWithUnionQuery (children 1)
 ExpressionList (children 1)
  SelectQuery (children 2)
   ExpressionList (children 19)
    Identifier entityIri
    Identifier watchers-count
    Identifier time-repeating-average
    Identifier reject-views-duration-average
    Identifier repeating-views-count-average
    Identifier views-duration-average
    Identifier watched-part-average
    Identifier rejects-count
    Identifier progress-average
    Identifier views-count-before-full-watched-average
    Identifier duration
    Identifier full-watched-learners-count
    Identifier overall-watchers-count
    Identifier overall-full-watched-learners-count
    Identifier views-count
    Identifier time-before-full-watched-average
    Function if (alias overall-watched-part) (children 1)
     ExpressionList (children 3)
      Function isNaN (children 1)
       ExpressionList (children 1)
        Function multiply (children 1)
         ExpressionList (children 2)
          Function divide (children 1)
           ExpressionList (children 2)
            Identifier overall-full-watched-learners-count
            Identifier overall-watchers-count
          Literal UInt64_100
      Literal UInt64_0
      Function multiply (children 1)
       ExpressionList (children 2)
        Function divide (children 1)
         ExpressionList (children 2)
          Identifier overall-full-watched-learners-count
          Identifier overall-watchers-count
        Literal UInt64_100
    Function if (alias full-watched-part) (children 1)
     ExpressionList (children 3)
      Function isNaN (children 1)
       ExpressionList (children 1)
        Function multiply (children 1)
         ExpressionList (children 2)
          Function divide (children 1)
           ExpressionList (children 2)
            Identifier full-watched-learners-count
            Identifier watchers-count
          Literal UInt64_100
      Literal UInt64_0
      Function multiply (children 1)
       ExpressionList (children 2)
        Function divide (children 1)
         ExpressionList (children 2)
          Identifier full-watched-learners-count
          Identifier watchers-count
        Literal UInt64_100
    Function if (alias rejects-part) (children 1)
     ExpressionList (children 3)
      Function isNaN (children 1)
       ExpressionList (children 1)
        Function multiply (children 1)
         ExpressionList (children 2)
          Function divide (children 1)
           ExpressionList (children 2)
            Identifier rejects-count
            Identifier views-count
          Literal UInt64_100
      Literal UInt64_0
      Function multiply (children 1)
       ExpressionList (children 2)
        Function divide (children 1)
         ExpressionList (children 2)
          Identifier rejects-count
          Identifier views-count
        Literal UInt64_100
   TablesInSelectQuery (children 1)
    TablesInSelectQueryElement (children 1)
     TableExpression (children 1)
      Subquery (children 1)
       SelectWithUnionQuery (children 1)
        ExpressionList (children 1)
         SelectQuery (children 2)
          ExpressionList (children 16)
           Identifier entityIri
           Identifier watchers-count
           Identifier time-repeating-average
           Identifier reject-views-duration-average
           Identifier repeating-views-count-average
           Identifier views-duration-average
           Identifier watched-part-average
           Identifier rejects-count
           Identifier progress-average
           Identifier views-count-before-full-watched-average
           Identifier duration
           Identifier full-watched-learners-count
           Identifier overall-watchers-count
           Identifier overall-full-watched-learners-count
           Identifier views-count
           Identifier time-before-full-watched-average
          TablesInSelectQuery (children 2)
           TablesInSelectQueryElement (children 1)
            TableExpression (children 1)
             Subquery (children 1)
              SelectWithUnionQuery (children 1)
               ExpressionList (children 1)
                SelectQuery (children 2)
                 ExpressionList (children 15)
                  Identifier entityIri
                  Identifier watchers-count
                  Identifier time-repeating-average
                  Identifier reject-views-duration-average
                  Identifier repeating-views-count-average
                  Identifier views-duration-average
                  Identifier watched-part-average
                  Identifier rejects-count
                  Identifier progress-average
                  Identifier views-count-before-full-watched-average
                  Identifier duration
                  Identifier full-watched-learners-count
                  Identifier overall-watchers-count
                  Identifier overall-full-watched-learners-count
                  Identifier views-count
                 TablesInSelectQuery (children 2)
                  TablesInSelectQueryElement (children 1)
                   TableExpression (children 1)
                    Subquery (children 1)
                     SelectWithUnionQuery (children 1)
                      ExpressionList (children 1)
                       SelectQuery (children 2)
                        ExpressionList (children 14)
                         Identifier entityIri
                         Identifier watchers-count
                         Identifier time-repeating-average
                         Identifier reject-views-duration-average
                         Identifier repeating-views-count-average
                         Identifier views-duration-average
                         Identifier watched-part-average
                         Identifier rejects-count
                         Identifier progress-average
                         Identifier views-count-before-full-watched-average
                         Identifier duration
                         Identifier full-watched-learners-count
                         Identifier overall-watchers-count
                         Identifier overall-full-watched-learners-count
                        TablesInSelectQuery (children 2)
                         TablesInSelectQueryElement (children 1)
                          TableExpression (children 1)
                           Subquery (children 1)
                            SelectWithUnionQuery (children 1)
                             ExpressionList (children 1)
                              SelectQuery (children 2)
                               ExpressionList (children 13)
                                Identifier entityIri
                                Identifier watchers-count
                                Identifier time-repeating-average
                                Identifier reject-views-duration-average
                                Identifier repeating-views-count-average
                                Identifier views-duration-average
                                Identifier watched-part-average
                                Identifier rejects-count
                                Identifier progress-average
                                Identifier views-count-before-full-watched-average
                                Identifier duration
                                Identifier full-watched-learners-count
                                Identifier overall-watchers-count
                               TablesInSelectQuery (children 2)
                                TablesInSelectQueryElement (children 1)
                                 TableExpression (children 1)
                                  Subquery (children 1)
                                   SelectWithUnionQuery (children 1)
                                    ExpressionList (children 1)
                                     SelectQuery (children 2)
                                      ExpressionList (children 12)
                                       Identifier entityIri
                                       Identifier watchers-count
                                       Identifier time-repeating-average
                                       Identifier reject-views-duration-average
                                       Identifier repeating-views-count-average
                                       Identifier views-duration-average
                                       Identifier watched-part-average
                                       Identifier rejects-count
                                       Identifier progress-average
                                       Identifier views-count-before-full-watched-average
                                       Identifier duration
                                       Identifier full-watched-learners-count
                                      TablesInSelectQuery (children 2)
                                       TablesInSelectQueryElement (children 1)
                                        TableExpression (children 1)
                                         Subquery (children 1)
                                          SelectWithUnionQuery (children 1)
                                           ExpressionList (children 1)
                                            SelectQuery (children 2)
                                             ExpressionList (children 11)
                                              Identifier entityIri
                                              Identifier watchers-count
                                              Identifier time-repeating-average
                                              Identifier reject-views-duration-average
                                              Identifier repeating-views-count-average
                                              Identifier views-duration-average
                                              Identifier watched-part-average
                                              Identifier rejects-count
                                              Identifier progress-average
                                              Identifier views-count-before-full-watched-average
                                              Identifier duration
                                             TablesInSelectQuery (children 2)
                                              TablesInSelectQueryElement (children 1)
                                               TableExpression (children 1)
                                                Subquery (children 1)
                                                 SelectWithUnionQuery (children 1)
                                                  ExpressionList (children 1)
                                                   SelectQuery (children 2)
                                                    ExpressionList (children 10)
                                                     Identifier entityIri
                                                     Identifier watchers-count
                                                     Identifier time-repeating-average
                                                     Identifier reject-views-duration-average
                                                     Identifier repeating-views-count-average
                                                     Identifier views-duration-average
                                                     Identifier watched-part-average
                                                     Identifier rejects-count
                                                     Identifier progress-average
                                                     Identifier views-count-before-full-watched-average
                                                    TablesInSelectQuery (children 2)
                                                     TablesInSelectQueryElement (children 1)
                                                      TableExpression (children 1)
                                                       Subquery (children 1)
                                                        SelectWithUnionQuery (children 1)
                                                         ExpressionList (children 1)
                                                          SelectQuery (children 2)
                                                           ExpressionList (children 9)
                                                            Identifier entityIri
                                                            Identifier watchers-count
                                                            Identifier time-repeating-average
                                                            Identifier reject-views-duration-average
                                                            Identifier repeating-views-count-average
                                                            Identifier views-duration-average
                                                            Identifier watched-part-average
                                                            Identifier rejects-count
                                                            Identifier progress-average
                                                           TablesInSelectQuery (children 2)
                                                            TablesInSelectQueryElement (children 1)
                                                             TableExpression (children 1)
                                                              Subquery (children 1)
                                                               SelectWithUnionQuery (children 1)
                                                                ExpressionList (children 1)
                                                                 SelectQuery (children 2)
                                                                  ExpressionList (children 8)
                                                                   Identifier entityIri
                                                                   Identifier watchers-count
                                                                   Identifier time-repeating-average
                                                                   Identifier reject-views-duration-average
                                                                   Identifier repeating-views-count-average
                                                                   Identifier views-duration-average
                                                                   Identifier watched-part-average
                                                                   Identifier rejects-count
                                                                  TablesInSelectQuery (children 2)
                                                                   TablesInSelectQueryElement (children 1)
                                                                    TableExpression (children 1)
                                                                     Subquery (children 1)
                                                                      SelectWithUnionQuery (children 1)
                                                                       ExpressionList (children 1)
                                                                        SelectQuery (children 2)
                                                                         ExpressionList (children 7)
                                                                          Identifier entityIri
                                                                          Identifier watchers-count
                                                                          Identifier time-repeating-average
                                                                          Identifier reject-views-duration-average
                                                                          Identifier repeating-views-count-average
                                                                          Identifier views-duration-average
                                                                          Identifier watched-part-average
                                                                         TablesInSelectQuery (children 2)
                                                                          TablesInSelectQueryElement (children 1)
                                                                           TableExpression (children 1)
                                                                            Subquery (children 1)
                                                                             SelectWithUnionQuery (children 1)
                                                                              ExpressionList (children 1)
                                                                               SelectQuery (children 2)
                                                                                ExpressionList (children 6)
                                                                                 Identifier entityIri
                                                                                 Identifier watchers-count
                                                                                 Identifier time-repeating-average
                                                                                 Identifier reject-views-duration-average
                                                                                 Identifier repeating-views-count-average
                                                                                 Identifier views-duration-average
                                                                                TablesInSelectQuery (children 2)
                                                                                 TablesInSelectQueryElement (children 1)
                                                                                  TableExpression (children 1)
                                                                                   Subquery (children 1)
                                                                                    SelectWithUnionQuery (children 1)
                                                                                     ExpressionList (children 1)
                                                                                      SelectQuery (children 2)
                                                                                       ExpressionList (children 5)
                                                                                        Identifier entityIri
                                                                                        Identifier watchers-count
                                                                                        Identifier time-repeating-average
                                                                                        Identifier reject-views-duration-average
                                                                                        Identifier repeating-views-count-average
                                                                                       TablesInSelectQuery (children 2)
                                                                                        TablesInSelectQueryElement (children 1)
                                                                                         TableExpression (children 1)
                                                                                          Subquery (children 1)
                                                                                           SelectWithUnionQuery (children 1)
                                                                                            ExpressionList (children 1)
                                                                                             SelectQuery (children 2)
                                                                                              ExpressionList (children 4)
                                                                                               Identifier entityIri
                                                                                               Identifier watchers-count
                                                                                               Identifier time-repeating-average
                                                                                               Identifier reject-views-duration-average
                                                                                              TablesInSelectQuery (children 2)
                                                                                               TablesInSelectQueryElement (children 1)
                                                                                                TableExpression (children 1)
                                                                                                 Subquery (children 1)
                                                                                                  SelectWithUnionQuery (children 1)
                                                                                                   ExpressionList (children 1)
                                                                                                    SelectQuery (children 2)
                                                                                                     ExpressionList (children 3)
                                                                                                      Identifier entityIri
                                                                                                      Identifier watchers-count
                                                                                                      Identifier time-repeating-average
                                                                                                     TablesInSelectQuery (children 2)
                                                                                                      TablesInSelectQueryElement (children 1)
                                                                                                       TableExpression (children 1)
                                                                                                        Subquery (children 1)
                                                                                                         SelectWithUnionQuery (children 1)
                                                                                                          ExpressionList (children 1)
                                                                                                           SelectQuery (children 2)
                                                                                                            ExpressionList (children 2)
                                                                                                             Identifier entityIri
                                                                                                             Identifier watchers-count
                                                                                                            TablesInSelectQuery (children 2)
                                                                                                             TablesInSelectQueryElement (children 1)
                                                                                                              TableExpression (children 1)
                                                                                                               Subquery (children 1)
                                                                                                                SelectWithUnionQuery (children 1)
                                                                                                                 ExpressionList (children 1)
                                                                                                                  SelectQuery (children 2)
                                                                                                                   ExpressionList (children 1)
                                                                                                                    Identifier entityIri
                                                                                                                   TablesInSelectQuery (children 1)
                                                                                                                    TablesInSelectQueryElement (children 1)
                                                                                                                     TableExpression (children 1)
                                                                                                                      TableIdentifier dict_string
                                                                                                             TablesInSelectQueryElement (children 2)
                                                                                                              TableExpression (children 1)
                                                                                                               Subquery (children 1)
                                                                                                                SelectWithUnionQuery (children 1)
                                                                                                                 ExpressionList (children 1)
                                                                                                                  SelectQuery (children 5)
                                                                                                                   ExpressionList (children 2)
                                                                                                                    Function uniq (alias watchers-count) (children 1)
                                                                                                                     ExpressionList (children 1)
                                                                                                                      Identifier learnerId
                                                                                                                    Identifier entityIri
                                                                                                                   TablesInSelectQuery (children 2)
                                                                                                                    TablesInSelectQueryElement (children 1)
                                                                                                                     TableExpression (children 1)
                                                                                                                      TableIdentifier video_views
                                                                                                                    TablesInSelectQueryElement (children 1)
                                                                                                                     ArrayJoin (children 1)
                                                                                                                      ExpressionList (children 1)
                                                                                                                       Identifier views
                                                                                                                   Function and (children 1)
                                                                                                                    ExpressionList (children 2)
                                                                                                                     Function in (children 1)
                                                                                                                      ExpressionList (children 2)
                                                                                                                       Identifier entityIri
                                                                                                                       Identifier dict_string
                                                                                                                     Function equals (children 1)
                                                                                                                      ExpressionList (children 2)
                                                                                                                       Identifier courseId
                                                                                                                       Literal UInt64_1
                                                                                                                   Function in (children 1)
                                                                                                                    ExpressionList (children 2)
                                                                                                                     Identifier learnerId
                                                                                                                     Identifier dict_ui64
                                                                                                                   ExpressionList (children 1)
                                                                                                                    Identifier entityIri
                                                                                                              TableJoin (children 1)
                                                                                                               ExpressionList (children 1)
                                                                                                                Identifier entityIri
                                                                                                      TablesInSelectQueryElement (children 2)
                                                                                                       TableExpression (children 1)
                                                                                                        Subquery (children 1)
                                                                                                         SelectWithUnionQuery (children 1)
                                                                                                          ExpressionList (children 1)
                                                                                                           SelectQuery (children 3)
                                                                                                            ExpressionList (children 2)
                                                                                                             Function avg (alias time-repeating-average) (children 1)
                                                                                                              ExpressionList (children 1)
                                                                                                               Identifier viewDurationSum
                                                                                                             Identifier entityIri
                                                                                                            TablesInSelectQuery (children 1)
                                                                                                             TablesInSelectQueryElement (children 1)
                                                                                                              TableExpression (children 1)
                                                                                                               Subquery (children 1)
                                                                                                                SelectWithUnionQuery (children 1)
                                                                                                                 ExpressionList (children 1)
                                                                                                                  SelectQuery (children 5)
                                                                                                                   ExpressionList (children 3)
                                                                                                                    Function sum (alias viewDurationSum) (children 1)
                                                                                                                     ExpressionList (children 1)
                                                                                                                      Identifier views.viewDuration
                                                                                                                    Identifier entityIri
                                                                                                                    Identifier learnerId
                                                                                                                   TablesInSelectQuery (children 2)
                                                                                                                    TablesInSelectQueryElement (children 1)
                                                                                                                     TableExpression (children 1)
                                                                                                                      TableIdentifier video_views
                                                                                                                    TablesInSelectQueryElement (children 1)
                                                                                                                     ArrayJoin (children 1)
                                                                                                                      ExpressionList (children 1)
                                                                                                                       Identifier views
                                                                                                                   Function and (children 1)
                                                                                                                    ExpressionList (children 2)
                                                                                                                     Function in (children 1)
                                                                                                                      ExpressionList (children 2)
                                                                                                                       Identifier entityIri
                                                                                                                       Identifier dict_string
                                                                                                                     Function equals (children 1)
                                                                                                                      ExpressionList (children 2)
                                                                                                                       Identifier courseId
                                                                                                                       Literal UInt64_1
                                                                                                                   Function and (children 1)
                                                                                                                    ExpressionList (children 2)
                                                                                                                     Function equals (children 1)
                                                                                                                      ExpressionList (children 2)
                                                                                                                       Identifier views.repeatingView
                                                                                                                       Literal UInt64_1
                                                                                                                     Function in (children 1)
                                                                                                                      ExpressionList (children 2)
                                                                                                                       Identifier learnerId
                                                                                                                       Identifier dict_ui64
                                                                                                                   ExpressionList (children 2)
                                                                                                                    Identifier learnerId
                                                                                                                    Identifier entityIri
                                                                                                            ExpressionList (children 1)
                                                                                                             Identifier entityIri
                                                                                                       TableJoin (children 1)
                                                                                                        ExpressionList (children 1)
                                                                                                         Identifier entityIri
                                                                                               TablesInSelectQueryElement (children 2)
                                                                                                TableExpression (children 1)
                                                                                                 Subquery (children 1)
                                                                                                  SelectWithUnionQuery (children 1)
                                                                                                   ExpressionList (children 1)
                                                                                                    SelectQuery (children 5)
                                                                                                     ExpressionList (children 2)
                                                                                                      Function avg (alias reject-views-duration-average) (children 1)
                                                                                                       ExpressionList (children 1)
                                                                                                        Identifier views.viewDuration
                                                                                                      Identifier entityIri
                                                                                                     TablesInSelectQuery (children 2)
                                                                                                      TablesInSelectQueryElement (children 1)
                                                                                                       TableExpression (children 1)
                                                                                                        TableIdentifier video_views
                                                                                                      TablesInSelectQueryElement (children 1)
                                                                                                       ArrayJoin (children 1)
                                                                                                        ExpressionList (children 1)
                                                                                                         Identifier views
                                                                                                     Function and (children 1)
                                                                                                      ExpressionList (children 2)
                                                                                                       Function in (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier entityIri
                                                                                                         Identifier dict_string
                                                                                                       Function equals (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier courseId
                                                                                                         Literal UInt64_1
                                                                                                     Function and (children 1)
                                                                                                      ExpressionList (children 2)
                                                                                                       Function equals (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier views.reject
                                                                                                         Literal UInt64_1
                                                                                                       Function in (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier learnerId
                                                                                                         Identifier dict_ui64
                                                                                                     ExpressionList (children 1)
                                                                                                      Identifier entityIri
                                                                                                TableJoin (children 1)
                                                                                                 ExpressionList (children 1)
                                                                                                  Identifier entityIri
                                                                                        TablesInSelectQueryElement (children 2)
                                                                                         TableExpression (children 1)
                                                                                          Subquery (children 1)
                                                                                           SelectWithUnionQuery (children 1)
                                                                                            ExpressionList (children 1)
                                                                                             SelectQuery (children 3)
                                                                                              ExpressionList (children 2)
                                                                                               Function avg (alias repeating-views-count-average) (children 1)
                                                                                                ExpressionList (children 1)
                                                                                                 Identifier viewsCount
                                                                                               Identifier entityIri
                                                                                              TablesInSelectQuery (children 1)
                                                                                               TablesInSelectQueryElement (children 1)
                                                                                                TableExpression (children 1)
                                                                                                 Subquery (children 1)
                                                                                                  SelectWithUnionQuery (children 1)
                                                                                                   ExpressionList (children 1)
                                                                                                    SelectQuery (children 5)
                                                                                                     ExpressionList (children 3)
                                                                                                      Function count (alias viewsCount) (children 1)
                                                                                                       ExpressionList
                                                                                                      Identifier learnerId
                                                                                                      Identifier entityIri
                                                                                                     TablesInSelectQuery (children 2)
                                                                                                      TablesInSelectQueryElement (children 1)
                                                                                                       TableExpression (children 1)
                                                                                                        TableIdentifier video_views
                                                                                                      TablesInSelectQueryElement (children 1)
                                                                                                       ArrayJoin (children 1)
                                                                                                        ExpressionList (children 1)
                                                                                                         Identifier views
                                                                                                     Function and (children 1)
                                                                                                      ExpressionList (children 2)
                                                                                                       Function equals (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier courseId
                                                                                                         Literal UInt64_1
                                                                                                       Function in (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier entityIri
                                                                                                         Identifier dict_string
                                                                                                     Function and (children 1)
                                                                                                      ExpressionList (children 2)
                                                                                                       Function equals (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier views.repeatingView
                                                                                                         Literal UInt64_1
                                                                                                       Function in (children 1)
                                                                                                        ExpressionList (children 2)
                                                                                                         Identifier learnerId
                                                                                                         Identifier dict_ui64
                                                                                                     ExpressionList (children 2)
                                                                                                      Identifier learnerId
                                                                                                      Identifier entityIri
                                                                                              ExpressionList (children 1)
                                                                                               Identifier entityIri
                                                                                         TableJoin (children 1)
                                                                                          ExpressionList (children 1)
                                                                                           Identifier entityIri
                                                                                 TablesInSelectQueryElement (children 2)
                                                                                  TableExpression (children 1)
                                                                                   Subquery (children 1)
                                                                                    SelectWithUnionQuery (children 1)
                                                                                     ExpressionList (children 1)
                                                                                      SelectQuery (children 5)
                                                                                       ExpressionList (children 2)
                                                                                        Function avg (alias views-duration-average) (children 1)
                                                                                         ExpressionList (children 1)
                                                                                          Identifier views.viewDuration
                                                                                        Identifier entityIri
                                                                                       TablesInSelectQuery (children 2)
                                                                                        TablesInSelectQueryElement (children 1)
                                                                                         TableExpression (children 1)
                                                                                          TableIdentifier video_views
                                                                                        TablesInSelectQueryElement (children 1)
                                                                                         ArrayJoin (children 1)
                                                                                          ExpressionList (children 1)
                                                                                           Identifier views
                                                                                       Function and (children 1)
                                                                                        ExpressionList (children 2)
                                                                                         Function in (children 1)
                                                                                          ExpressionList (children 2)
                                                                                           Identifier entityIri
                                                                                           Identifier dict_string
                                                                                         Function equals (children 1)
                                                                                          ExpressionList (children 2)
                                                                                           Identifier courseId
                                                                                           Literal UInt64_1
                                                                                       Function in (children 1)
                                                                                        ExpressionList (children 2)
                                                                                         Identifier learnerId
                                                                                         Identifier dict_ui64
                                                                                       ExpressionList (children 1)
                                                                                        Identifier entityIri
                                                                                  TableJoin (children 1)
                                                                                   ExpressionList (children 1)
                                                                                    Identifier entityIri
                                                                          TablesInSelectQueryElement (children 2)
                                                                           TableExpression (children 1)
                                                                            Subquery (children 1)
                                                                             SelectWithUnionQuery (children 1)
                                                                              ExpressionList (children 1)
                                                                               SelectQuery (children 5)
                                                                                ExpressionList (children 2)
                                                                                 Function avg (alias watched-part-average) (children 1)
                                                                                  ExpressionList (children 1)
                                                                                   Identifier views.watchedPart
                                                                                 Identifier entityIri
                                                                                TablesInSelectQuery (children 2)
                                                                                 TablesInSelectQueryElement (children 1)
                                                                                  TableExpression (children 1)
                                                                                   TableIdentifier video_views
                                                                                 TablesInSelectQueryElement (children 1)
                                                                                  ArrayJoin (children 1)
                                                                                   ExpressionList (children 1)
                                                                                    Identifier views
                                                                                Function and (children 1)
                                                                                 ExpressionList (children 2)
                                                                                  Function in (children 1)
                                                                                   ExpressionList (children 2)
                                                                                    Identifier entityIri
                                                                                    Identifier dict_string
                                                                                  Function equals (children 1)
                                                                                   ExpressionList (children 2)
                                                                                    Identifier courseId
                                                                                    Literal UInt64_1
                                                                                Function in (children 1)
                                                                                 ExpressionList (children 2)
                                                                                  Identifier learnerId
                                                                                  Identifier dict_ui64
                                                                                ExpressionList (children 1)
                                                                                 Identifier entityIri
                                                                           TableJoin (children 1)
                                                                            ExpressionList (children 1)
                                                                             Identifier entityIri
                                                                   TablesInSelectQueryElement (children 2)
                                                                    TableExpression (children 1)
                                                                     Subquery (children 1)
                                                                      SelectWithUnionQuery (children 1)
                                                                       ExpressionList (children 1)
                                                                        SelectQuery (children 5)
                                                                         ExpressionList (children 2)
                                                                          Function count (alias rejects-count) (children 1)
                                                                           ExpressionList
                                                                          Identifier entityIri
                                                                         TablesInSelectQuery (children 2)
                                                                          TablesInSelectQueryElement (children 1)
                                                                           TableExpression (children 1)
                                                                            TableIdentifier video_views
                                                                          TablesInSelectQueryElement (children 1)
                                                                           ArrayJoin (children 1)
                                                                            ExpressionList (children 1)
                                                                             Identifier views
                                                                         Function and (children 1)
                                                                          ExpressionList (children 2)
                                                                           Function in (children 1)
                                                                            ExpressionList (children 2)
                                                                             Identifier entityIri
                                                                             Identifier dict_string
                                                                           Function equals (children 1)
                                                                            ExpressionList (children 2)
                                                                             Identifier courseId
                                                                             Literal UInt64_1
                                                                         Function and (children 1)
                                                                          ExpressionList (children 2)
                                                                           Function equals (children 1)
                                                                            ExpressionList (children 2)
                                                                             Identifier views.reject
                                                                             Literal UInt64_1
                                                                           Function in (children 1)
                                                                            ExpressionList (children 2)
                                                                             Identifier learnerId
                                                                             Identifier dict_ui64
                                                                         ExpressionList (children 1)
                                                                          Identifier entityIri
                                                                    TableJoin (children 1)
                                                                     ExpressionList (children 1)
                                                                      Identifier entityIri
                                                            TablesInSelectQueryElement (children 2)
                                                             TableExpression (children 1)
                                                              Subquery (children 1)
                                                               SelectWithUnionQuery (children 1)
                                                                ExpressionList (children 1)
                                                                 SelectQuery (children 3)
                                                                  ExpressionList (children 2)
                                                                   Function avg (alias progress-average) (children 1)
                                                                    ExpressionList (children 1)
                                                                     Identifier progressMax
                                                                   Identifier entityIri
                                                                  TablesInSelectQuery (children 1)
                                                                   TablesInSelectQueryElement (children 1)
                                                                    TableExpression (children 1)
                                                                     Subquery (children 1)
                                                                      SelectWithUnionQuery (children 1)
                                                                       ExpressionList (children 1)
                                                                        SelectQuery (children 5)
                                                                         ExpressionList (children 3)
                                                                          Function max (alias progressMax) (children 1)
                                                                           ExpressionList (children 1)
                                                                            Identifier views.progress
                                                                          Identifier entityIri
                                                                          Identifier learnerId
                                                                         TablesInSelectQuery (children 2)
                                                                          TablesInSelectQueryElement (children 1)
                                                                           TableExpression (children 1)
                                                                            TableIdentifier video_views
                                                                          TablesInSelectQueryElement (children 1)
                                                                           ArrayJoin (children 1)
                                                                            ExpressionList (children 1)
                                                                             Identifier views
                                                                         Function and (children 1)
                                                                          ExpressionList (children 2)
                                                                           Function in (children 1)
                                                                            ExpressionList (children 2)
                                                                             Identifier entityIri
                                                                             Identifier dict_string
                                                                           Function equals (children 1)
                                                                            ExpressionList (children 2)
                                                                             Identifier courseId
                                                                             Literal UInt64_1
                                                                         Function in (children 1)
                                                                          ExpressionList (children 2)
                                                                           Identifier learnerId
                                                                           Identifier dict_ui64
                                                                         ExpressionList (children 2)
                                                                          Identifier learnerId
                                                                          Identifier entityIri
                                                                  ExpressionList (children 1)
                                                                   Identifier entityIri
                                                             TableJoin (children 1)
                                                              ExpressionList (children 1)
                                                               Identifier entityIri
                                                     TablesInSelectQueryElement (children 2)
                                                      TableExpression (children 1)
                                                       Subquery (children 1)
                                                        SelectWithUnionQuery (children 1)
                                                         ExpressionList (children 1)
                                                          SelectQuery (children 5)
                                                           ExpressionList (children 2)
                                                            Function avg (alias views-count-before-full-watched-average) (children 1)
                                                             ExpressionList (children 1)
                                                              Identifier fullWatchedViews
                                                            Identifier entityIri
                                                           TablesInSelectQuery (children 1)
                                                            TablesInSelectQueryElement (children 1)
                                                             TableExpression (children 1)
                                                              TableIdentifier video_views
                                                           Function and (children 1)
                                                            ExpressionList (children 2)
                                                             Function in (children 1)
                                                              ExpressionList (children 2)
                                                               Identifier entityIri
                                                               Identifier dict_string
                                                             Function equals (children 1)
                                                              ExpressionList (children 2)
                                                               Identifier courseId
                                                               Literal UInt64_1
                                                           Function in (children 1)
                                                            ExpressionList (children 2)
                                                             Identifier learnerId
                                                             Identifier dict_ui64
                                                           ExpressionList (children 1)
                                                            Identifier entityIri
                                                      TableJoin (children 1)
                                                       ExpressionList (children 1)
                                                        Identifier entityIri
                                              TablesInSelectQueryElement (children 2)
                                               TableExpression (children 1)
                                                Subquery (children 1)
                                                 SelectWithUnionQuery (children 1)
                                                  ExpressionList (children 1)
                                                   SelectQuery (children 5)
                                                    ExpressionList (children 2)
                                                     Function any (alias duration) (children 1)
                                                      ExpressionList (children 1)
                                                       Identifier duration
                                                     Identifier entityIri
                                                    TablesInSelectQuery (children 1)
                                                     TablesInSelectQueryElement (children 1)
                                                      TableExpression (children 1)
                                                       TableIdentifier video_views
                                                    Function and (children 1)
                                                     ExpressionList (children 2)
                                                      Function in (children 1)
                                                       ExpressionList (children 2)
                                                        Identifier entityIri
                                                        Identifier dict_string
                                                      Function equals (children 1)
                                                       ExpressionList (children 2)
                                                        Identifier courseId
                                                        Literal UInt64_1
                                                    Function in (children 1)
                                                     ExpressionList (children 2)
                                                      Identifier learnerId
                                                      Identifier dict_ui64
                                                    ExpressionList (children 1)
                                                     Identifier entityIri
                                               TableJoin (children 1)
                                                ExpressionList (children 1)
                                                 Identifier entityIri
                                       TablesInSelectQueryElement (children 2)
                                        TableExpression (children 1)
                                         Subquery (children 1)
                                          SelectWithUnionQuery (children 1)
                                           ExpressionList (children 1)
                                            SelectQuery (children 5)
                                             ExpressionList (children 2)
                                              Function uniq (alias full-watched-learners-count) (children 1)
                                               ExpressionList (children 1)
                                                Identifier learnerId
                                              Identifier entityIri
                                             TablesInSelectQuery (children 1)
                                              TablesInSelectQueryElement (children 1)
                                               TableExpression (children 1)
                                                TableIdentifier video_views
                                             Function and (children 1)
                                              ExpressionList (children 2)
                                               Function in (children 1)
                                                ExpressionList (children 2)
                                                 Identifier entityIri
                                                 Identifier dict_string
                                               Function equals (children 1)
                                                ExpressionList (children 2)
                                                 Identifier courseId
                                                 Literal UInt64_1
                                             Function and (children 1)
                                              ExpressionList (children 2)
                                               Function equals (children 1)
                                                ExpressionList (children 2)
                                                 Identifier fullWatched
                                                 Literal UInt64_1
                                               Function in (children 1)
                                                ExpressionList (children 2)
                                                 Identifier learnerId
                                                 Identifier dict_ui64
                                             ExpressionList (children 1)
                                              Identifier entityIri
                                        TableJoin (children 1)
                                         ExpressionList (children 1)
                                          Identifier entityIri
                                TablesInSelectQueryElement (children 2)
                                 TableExpression (children 1)
                                  Subquery (children 1)
                                   SelectWithUnionQuery (children 1)
                                    ExpressionList (children 1)
                                     SelectQuery (children 5)
                                      ExpressionList (children 2)
                                       Function uniq (alias overall-watchers-count) (children 1)
                                        ExpressionList (children 1)
                                         Identifier learnerId
                                       Identifier entityIri
                                      TablesInSelectQuery (children 2)
                                       TablesInSelectQueryElement (children 1)
                                        TableExpression (children 1)
                                         TableIdentifier video_views
                                       TablesInSelectQueryElement (children 1)
                                        ArrayJoin (children 1)
                                         ExpressionList (children 1)
                                          Identifier views
                                      Function and (children 1)
                                       ExpressionList (children 2)
                                        Function in (children 1)
                                         ExpressionList (children 2)
                                          Identifier entityIri
                                          Identifier dict_string
                                        Function equals (children 1)
                                         ExpressionList (children 2)
                                          Identifier courseId
                                          Literal UInt64_1
                                      Function in (children 1)
                                       ExpressionList (children 2)
                                        Identifier learnerId
                                        Identifier dict_ui64
                                      ExpressionList (children 1)
                                       Identifier entityIri
                                 TableJoin (children 1)
                                  ExpressionList (children 1)
                                   Identifier entityIri
                         TablesInSelectQueryElement (children 2)
                          TableExpression (children 1)
                           Subquery (children 1)
                            SelectWithUnionQuery (children 1)
                             ExpressionList (children 1)
                              SelectQuery (children 5)
                               ExpressionList (children 2)
                                Function uniq (alias overall-full-watched-learners-count) (children 1)
                                 ExpressionList (children 1)
                                  Identifier learnerId
                                Identifier entityIri
                               TablesInSelectQuery (children 1)
                                TablesInSelectQueryElement (children 1)
                                 TableExpression (children 1)
                                  TableIdentifier video_views
                               Function and (children 1)
                                ExpressionList (children 2)
                                 Function in (children 1)
                                  ExpressionList (children 2)
                                   Identifier entityIri
                                   Identifier dict_string
                                 Function equals (children 1)
                                  ExpressionList (children 2)
                                   Identifier courseId
                                   Literal UInt64_1
                               Function and (children 1)
                                ExpressionList (children 2)
                                 Function equals (children 1)
                                  ExpressionList (children 2)
                                   Identifier fullWatched
                                   Literal UInt64_1
                                 Function in (children 1)
                                  ExpressionList (children 2)
                                   Identifier learnerId
                                   Identifier dict_ui64
                               ExpressionList (children 1)
                                Identifier entityIri
                          TableJoin (children 1)
                           ExpressionList (children 1)
                            Identifier entityIri
                  TablesInSelectQueryElement (children 2)
                   TableExpression (children 1)
                    Subquery (children 1)
                     SelectWithUnionQuery (children 1)
                      ExpressionList (children 1)
                       SelectQuery (children 5)
                        ExpressionList (children 2)
                         Function count (alias views-count) (children 1)
                          ExpressionList
                         Identifier entityIri
                        TablesInSelectQuery (children 2)
                         TablesInSelectQueryElement (children 1)
                          TableExpression (children 1)
                           TableIdentifier video_views
                         TablesInSelectQueryElement (children 1)
                          ArrayJoin (children 1)
                           ExpressionList (children 1)
                            Identifier views
                        Function and (children 1)
                         ExpressionList (children 2)
                          Function in (children 1)
                           ExpressionList (children 2)
                            Identifier entityIri
                            Identifier dict_string
                          Function equals (children 1)
                           ExpressionList (children 2)
                            Identifier courseId
                            Literal UInt64_1
                        Function in (children 1)
                         ExpressionList (children 2)
                          Identifier learnerId
                          Identifier dict_ui64
                        ExpressionList (children 1)
                         Identifier entityIri
                   TableJoin (children 1)
                    ExpressionList (children 1)
                     Identifier entityIri
           TablesInSelectQueryElement (children 2)
            TableExpression (children 1)
             Subquery (children 1)
              SelectWithUnionQuery (children 1)
               ExpressionList (children 1)
                SelectQuery (children 5)
                 ExpressionList (children 2)
                  Function avg (alias time-before-full-watched-average) (children 1)
                   ExpressionList (children 1)
                    Identifier fullWatchedTime
                  Identifier entityIri
                 TablesInSelectQuery (children 1)
                  TablesInSelectQueryElement (children 1)
                   TableExpression (children 1)
                    TableIdentifier video_views
                 Function and (children 1)
                  ExpressionList (children 2)
                   Function in (children 1)
                    ExpressionList (children 2)
                     Identifier entityIri
                     Identifier dict_string
                   Function equals (children 1)
                    ExpressionList (children 2)
                     Identifier courseId
                     Literal UInt64_1
                 Function in (children 1)
                  ExpressionList (children 2)
                   Identifier learnerId
                   Identifier dict_ui64
                 ExpressionList (children 1)
                  Identifier entityIri
            TableJoin (children 1)
             ExpressionList (children 1)
              Identifier entityIri
