SQL Joins Explainer Guide-2

Explain the difference between SQL INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. Use 2 small sample tables (users and orders, 5 rows each) to show the input data and the exact output table of each join type. Write the SQL queries for each.