1.)Warming up with aggregate functions: return the total price of all items in the items table and how many of them there are.

2.)Return the money spent and the number of items bought per customer.

3.)Similar to the last problem, but one step deeper: return the money spent and the number of items bought per customer, per cart.

4.)How many different items did each customer buy (not quantity)? Return customer name and number of different items. Hint: A. Jones bought 2 different items.

cartitem -Table Name: cartite Schema: superma Column PK NNU cartid item id qty price INT INT SMALLINT DECIMAL(16,4) click to edit>