More on Subqueries

The following examples of subqueries, using subqueries inside SELECT statements and in the FROM clause, use the Ice Cream Shop database located here.

Subqueries inside SELECT statements:

1. /*  Using subquery in SELECT statement.
2.     This example uses the IceCreamStore database.
3. */
5. SELECT (SELECT SUM(F.flavorID)) AS 'Varieties Available', B.Name AS 'Brand Name'
6. FROM Flavors AS F
7. INNER JOIN xBrandFlavorDistributors AS XFD
8. ON Xfd.flavorID = F.flavorID
9. INNER JOIN Brands AS B
10. ON XFD.brandID = B.brandID
11. GROUP BY B.Name;

Subqueries inside the FROM clause:

1. /*  Using subquery in FROM clause.
2.     This example uses the IceCreamStore database.
3. */
5. SELECT F.Name
6. FROM (
7.         SELECT * FROM Flavors
8.      ) AS F