Homework - In the previous section, you loaded the following 6 tables.Use these tables to answer the following questions.

Return the query to return the answer for the following questions...

1.How many are active from each group.Return the answers in one query and put the results in a table variable.

a. Paths

b. Courses

c. Sections

d. Events

2. How many documents have been created but not attached to the Curriculum.

3. How many active events are there in each Course?Sort from largest to smallest

4. Create View that outlines the whole curriculum in the correct order.

5. How many of each Event Type's are included in the Active Curriculum.

6. Create P that accepts CourseID as a parameter and returns SectionName, DocumentName and EventType's stored in the Course passed into the SP.