Aggregate Data in SQL using MySQL Workbench

ofrecido por
Coursera Project Network
En este proyecto guiado, tú:

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
IntermediateIntermedio
CloudNo se necesita descarga
VideoVideo de pantalla dividida
Comment DotsInglés (English)
LaptopSolo escritorio

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.

Habilidades que desarrollarás

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

Aprende paso a paso

En un video que se reproduce en una pantalla dividida con tu área de trabajo, tu instructor te guiará en cada paso:

  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.

Cómo funcionan los proyectos guiados

Tu espacio de trabajo es un escritorio virtual directamente en tu navegador, no requiere descarga.

En un video de pantalla dividida, tu instructor te guía paso a paso

Preguntas Frecuentes

Preguntas Frecuentes

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.