MySQL Subquery: How to write subqueries?

Subqueries are important and used to answer complex questions. In this video, the general structure of subquery is discussed.
0:00 Introduction to Subquery
0:55 Subquery in Where Clause
8:20 Subquery in Select Clause
13:04 Subquery in From Clause