What is the benefit of 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.