The sub query must follow the below rules:
1. Subqueries are always written within the parentheses.
2. Always place the Subquery on the right side of the comparison operator.
3. ORDER BY clause is not used in sub query, since Subqueries cannot manipulate the results internally.