Guidelines for using subquery

• Enclose subqueries in parantheses.
• Place subqueries on the right side of the comparison condition.
• The ORDER BY clause in the subquery is not needed unless you re performing TOP-N analysis.
• Using single-row operators with single-row subqueries, and use multiple-row operators with multiple-row subqueries.