SQL JOIN Types Quick Reference Guide

SQL Join types overview and tutorial

SQL OUTER JOIN overview and examples

An overview of the SQL GROUP BY clause

SQL GROUP BY to Summarize and Rollup Query Results

SQL PARTITION BY Clause overview

A step-by-step walkthrough of SQL Inner Join

SQL Joins (Inner, Left, Right and Full Join) - GeeksforGeeks

SQL UPDATE from SELECT, JOIN or MERGE