In einem Video, das auf einer Hälfte Ihres Arbeitsbereichs abgespielt wird, führt Sie Ihr Dozent durch diese Schritte:

1. •

   Examine and execute an SQL query that uses the Group and Count functions in MySQL Workbench to count the number of orders placed by each customer.

2. •

   Group by customer and product name and use the SQL COUNT aggregate function to display the total number of items on each order for each customer.

3. •

   After calculating the amount due for each product, use the SQL SUM aggregate function and the GROUP BY clause to calculate the total sales amount for each order.

4. •

   Write SQL code in MySQL Workbench that incorporates the Group, Count, Min, Max, and Avg functions to produce statistics for analyzing purchasing patterns.

5. •

   Group by customer and order, using the HAVING clause to filter for orders with more than one item per order.