Aggregate Data in SQL using MySQL Workbench

提供方
Coursera Project Network
在此指導項目中,您將:

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
Intermediate中級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

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.

您要培養的技能

  • Mysql Workbench
  • Group By
  • SQL code
  • SQL Aggregate Functions
  • Data Aggregation

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  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.

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心