"Using the AdventureWorksDW2012 database, list the customers who have purchased BOTH a touring bike and a hydration pack." (Subquerry in SQL)

1. True or False. The following would be a code solution for the business question posed above:

use AdventureWorksDW2012;

select distinct c.CustomerKey from DimCustomer as c inner join FactInternetSales as fis on c.CustomerKey = fis.CustomerKey inner join DimProduct as p on fis.ProductKey = p.ProductKey where p.ProductSubcategoryKey = 3 and p.ProductSubcategoryKey = 32;

2. From the AdventureWorksDW2012 database, determine the number of customers from the Customers table.
3. From the AdventureWorksDW2012 database, determine how many customers have made at least one purchase from the Touring Bike subcategory (subcategory 3).
4. From the AdventureWorksDW2012 database, determine how many customers have made at least one purchase from the Hydration Pack subcategory (subcategory 32).