What is the total party cost charged to each customer? Display the CustomerID, FirstName, LastName, and the Total Party
Posted: Wed May 04, 2022 6:32 am
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 party’s 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
LastName, and the Total Party Cost charged for that customer. Name the query as Total Party Cost
by Each Customer. (Hint: Each party’s 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