queryBatmanByRating.kotlin

    println("Ratings query took : ${measureTimeMillis() {
        transaction(db) {
            var result = (Titles innerJoin Ratings).slice(Titles.primaryTitle, Titles.titleType, Ratings.averageRating, Ratings.numVotes).select {
                ((Titles.primaryTitle like "%batman%") and (Titles.titleType like "movie")
                        and Titles.tconst.eq(Ratings.tconst))
            }.orderBy(Ratings.averageRating)
                .toList()

            println(result.size)
            println(result)
            println(result.last())
        }
    }}");