Aggregate Data in SQL using MySQL Workbench

位教师：Judy Richardson

访问权限由 New York State Department of Labor 提供

2,128 人已注册

指导项目

在专家的指导下，学习、练习并应用工作就绪技能

中级等级

推荐体验

2 hours

自行安排学习进度

实践学习

了解更多

指导项目

在专家的指导下，学习、练习并应用工作就绪技能

中级等级

推荐体验

2 hours

自行安排学习进度

实践学习

了解更多

您将学到什么

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.

您将练习的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

授课语言：英语（English）

无需下载或安装

仅桌面可用

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

在 2 小时内学习、练习并应用岗位必备技能

接受行业专家的培训
获得解决实训工作任务的实践经验
使用最新的工具和技术来建立信心

关于此指导项目

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.

分步进行学习

在与您的工作区一起在分屏中播放的视频中，您的授课教师将指导您完成每个步骤：

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.
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.
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.
Write SQL code in MySQL Workbench that incorporates the Group, Count, Min, Max, and Avg functions to produce statistics for analyzing purchasing patterns.
Group by customer and order, using the HAVING clause to filter for orders with more than one item per order.