SQL Subquery

The SQL subquery is a separate SELECT statement that is embedded in the main statement and may be executed once for each row of the result set... ... This is another example that could have been done more efficiently with a GROUP BY and HAVING ...

www.sql-server-pro.com