How to Make SQL Easier to Understand for Developers (gmoniava.com)

Pretty usefull, "if we remove the if (matchingOrders.length === 0) block, we get the equivalent of an INNER JOIN" - nice to know.