Completed TopFilms Query
Here's the completed query:
—TopFilms—
TopFilms
Query TopFilms() As %SQLQuery(CONTAINID = 1)
{
SELECT %ID,Description,Length,Rating,Title,Category->CategoryName
FROM Film
WHERE (PlayingNow = 1)
ORDER BY TicketsSold DESC
}