List all columns and all records in the Item table. Sort the results by item number within category. List the category and the sum of the items on hand. Group the results by category. Create a new...

List all columns and all records in the Item table. Sort the results by item number within category.

List the category and the sum of the items on hand. Group the results by category.

Create a new table named Toy to contain the columns ItemNum, Description, OnHand, and Price for all rows on

which the category is TOY.