How to write Subquery in SQL

A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.