Examples of subqueries in SQL for various scenarios such as finding the highest grade, most recent user, highest priced product, lowest grade student, and highest balance account.