[nzealand]

Try a Bayesian sort.

You will get a better result.

SELECT * EXCLUDE (titleType, primaryTitle, language) FROM 'imdb01-11-2024.parquet' WHERE (region is null and titleType = 'movie') ORDER BY ( (numVotes * averageRating)+(1000007))/ (numVotes+1000000) desc LIMIT 100

[afiodorov]

That's awesome. Care to explain? Looks like Laplace estimator of some kind?

P.S. Query sharing is supported:

https://www.imdb-sql.com/?query=SELECT+*+EXCLUDE+%28titleTyp...

[afiodorov]

Ah 7 might have been a typo. May be it was meant to be *7? Then that's exactly the Laplace estimator. We start with a prior of 1_000_000 votes of 7.0 and then adjust as we accumulate real votes.

[nzealand]

Yup. The correct query is:

SELECT * EXCLUDE (titleType, primaryTitle, language) FROM 'imdb01-11-2024.parquet' WHERE (region is null and titleType = 'movie') ORDER BY ( (numVotes * averageRating)+(100000 * 7))/ (numVotes+100000) desc LIMIT 100