Understanding the Difference Between Derived Tables and Scalar Subqueries in SQL

In MySQL