Modifying the TopFilms Query

To reduce the number of films we see, we need to modify the TopFilms query. Let's return to the Studio and modify the TopFilms query.

The definition of the TopFilms query is displayed within the Studio Class Editor window:

TopFilms

   Query TopFilms() As %SQLQuery(CONTAINID = 1)
    {
        SELECT %ID,Description,Length,Rating,Title,Category->CategoryName 
        FROM Film
        WHERE (PlayingNow = 1)
        ORDER BY TicketsSold DESC
    }