Write a query to display the number of products within each base and type combination, sorted by the base and then by type.

Write the answer to each query and the result of the query (screen capture). You should submit all design work, program documentation, and relevant sample screen shots of your implementation.

A script file with all database creation and table populating is required.