SQL Sub-query that Returns Single Value: Best Example

Sub queries are like queries with in the query. You can write subquery such that it will return single value or multiple values. Read more example and explanation.