This folder contains samples and scripts for chapter 5.

5-001 -- Not included: not an SQL statement
5-002 -- Not included: not an SQL statement
5-003 -- Not included: not an SQL statement
5-004 -- Not included: Access does not support GROUP BY ROLLUP
5-005 -- Not included: Access does not support GROUP BY CUBE
5-006 -- Not included: Access does not support GROUP BY GROUPING SET
5-007 -- Contained as query Listing 5-007 in Item30Example.accdb (in the Sample Databases folder)
5-008 -- Contained as query Listing 5-008 in Item30Example.accdb (in the Sample Databases folder)
5-009 -- Contained as query Listing 5-009 in Item30Example.accdb (in the Sample Databases folder)
5-010 -- Contained as query Listing 5-010 in SalesOrdersSample.accdb (in the Sample Databases folder)
5-011 -- Not supported in Access
5-012 -- Contained as query Listing 5-012 in SalesOrdersSample.accdb (in the Sample Databases folder)
5-013 -- Contained as query Listing 5-013 in SalesOrdersSample.accdb (in the Sample Databases folder)
5-014 -- Contained as query Listing 5-014 in SalesOrdersSample.accdb (in the Sample Databases folder)
5-015 -- Contained as queries Listing 5-015a, Listing 5-015b, and Listing 5-015 in 
          SalesOrdersSample.accdb (in the Sample Databases folder)
5-016
5-017 -- Contained as query Listing 5-017 in Item33Example.accdb (in the Sample Databases folder)
5-018 -- Contained as query Listing 5-018 in Item33Example.accdb (in the Sample Databases folder)
5-019 -- Contained as query Listing 5-019 in Item33Example.accdb (in the Sample Databases folder)
5-020 -- Contained as query Listing 5-020 in Item33Example.accdb (in the Sample Databases folder)
5-021 -- Contained as query Listing 5-021 in RecipesSample.accdb (in the Sample Databases folder)
5-022 -- Contained as query Listing 5-022 in RecipesSample.accdb (in the Sample Databases folder)
5-023 -- Contained as query Listing 5-023 in RecipesSample.accdb (in the Sample Databases folder)
5-024 -- Contained as query Listing 5-024 in RecipesSample.accdb (in the Sample Databases folder)
5-025 -- Contained as query Listing 5-025 in RecipesSample.accdb (in the Sample Databases folder)
5-026 -- Contained as query Listing 5-026 in RecipesSample.accdb (in the Sample Databases folder)
5-027 -- Contained as query Listing 5-027 in Item36Example.accdb (in the Sample Databases folder)
5-028 -- Contained as query Listing 5-030 in Item36Example.accdb  (in the Sample Databases folder)
         (but not all of the calculations are possible in Access)
5-029 -- Not supported in Access
5-030 -- Not supported in Access
5-031 -- Not supported in Access
5-032 -- Not supported in Access
5-033 -- Not supported in Access
5-034 -- Not supported in Access

