I learned this and more earlier from https://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete-understanding-of-sql/ https://blog.jooq.org/2016/03/17/10-easy

I learned this and more earlier from https://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete-understanding-of-sql/ https://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete... my goto guide and recommendation for people with practical SQL experience who want to improve their understanding. (I first read it via Hadley Wickham's tidy data writeup.) It leaves out SQL window functions though.