What is the total party cost charged to each customer? Display the CustomerID, FirstName,

LastName, and the Total Party Cost charged for that customer. Name the query as Total Party Cost

by Each Customer. (Hint: Each partys cost can be calculated by multiplying the number of people

attended in a party with the price per person.)

5. What is the total number of parties and the average of party size categorized by each party type?

Display the PartyType, the Number of Parties, and the Average of Party Size for each party type.

Name the query as Party Statistics by Each Party Type.

6. What is the total number of attendants invited by each customer? Display the CustomerID,

FirstName, LastName, and the Total Number of Attendants that a customer invited. Name the query

as Party Statistics by Each Customer