My second #sql blog post is up with a mental model for understanding JOINs.
https://thoughtbot.com/blog/understanding-sql-join
Sorry for the self-promo, but I'm particularly proud of these.
And the final #sql post tackling a step-by-step explanation of GROUP BY
https://thoughtbot.com/blog/understanding-sql-group-by
This is something I struggled with a lot early on and I'm excited to share my mental model.
The article even has some helpful illustrations that even respond to Dark Mode™ via the power of SVG