Aggregate Data in SQL using MySQL Workbench

Offered By
Coursera Project Network
In this Guided Project, you will:

Recognize ways in which aggregated data can improve the decision-making process.

Incorporate the GROUP BY clause in SQL to aggregate data.

Demonstrate the use of SQL aggregate functions using MySQL Workbench.

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this project you will use MySQL Workbench to write SQL queries that aggregate (group) data. Incorporating aggregate functions like COUNT, SUM, and AVG, your SQL queries will group and summarize data. Data that is aggregated and presented in a logical format makes it a more valuable decision-making tool for users. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Skills you will develop

Mysql WorkbenchGroup BySQL codeSQL Aggregate FunctionsData Aggregation

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  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.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.