The two types of subqueries are:
Single-row subquery, Double-row subquery
Double-row subquery, Multiple-row subquery
Multiple-row subquery
Single-row subquery and Multiple subquery