Databases & SQL

Short answers about Databases & SQL. One topic, one working example, no fluff.

• Databases & SQLSQL JOIN vs LEFT JOIN with examplesLearn the difference between SQL JOIN and LEFT JOIN with a customers and orders example, and see exactly which rows each one keeps.November 1, 2026 · 2 min read
• Databases & SQLSQL GROUP BY and HAVING explained with examplesLearn how SQL GROUP BY totals rows per group with SUM and COUNT, and how HAVING filters those groups, with a runnable example and output.October 28, 2026 · 2 min read