SUBQUERIES:  SYNTAX

 

            SELECT column list

            FROM table(s)

            WHERE [column] [ IN   |

                                           <comparison>  |

                                            EXISTS]

                        (SELECT column list

                        FROM table(s)

                         ... )

            GROUP BY ...

            HAVING ...

            ORDER BY