TIL: SQL Window Functions (and why Amazon wouldn’t publish my book review)

Tom Deneire
2 min readMay 25, 2023
Cover “SQL Window Functions Explained” by Anton Zhivanov

SQL Window Functions Explained

Last weekend I took some time to dig into SQL window functions. Being an avid user of SQL (especially SQLite), I figured it was high time I did something about my staggering lack of knowledge on the topic 😊

Moreover, I was fortunate enough to receive a gift copy of “SQL Window Functions Explained” from the author Anton Zhivanov:

So there were no more excuses!

Having read and thoroughly enjoyed the book, I wanted to publish a five-star review on Amazon, but, to my surprise, I wasn’t able to. Amazon community guidelines don’t allow you to write reviews if you don’t meet certain criteria, such as spending at least $50 in the past year. Which I haven’t…


So, if I can’t share my review on Amazon, I might as well do it here. In short, this is a really good book and a must for anyone who is looking to do some serious SQL’ing!

“SQL Window Functions…