Understanding MySQL Joins and Subqueries: A Deeper Dive into Complex Queries for Beginners with Examples