New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

PostgreSQL: Agregación y GROUP BY (Medio)

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

PostgreSQL: Agregación y GROUP BY (Medio)

Quiz

Played 0
Create copy

About this activity

Quiz intermedio de agregación

Created by

Magenta
Magenta
Peru

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
PostgreSQL: Agregación y GROUP BY (Medio)
 

PostgreSQL: Agregación y GROUP BY (Medio)Online version

Quiz intermedio de agregación

by Magenta
1

En una tabla ventas(id, canal, monto), ¿qué cláusula agrupa las filas para calcular un total por canal?

2

Para obtener el total de montos de ventas, ¿qué función usarías sobre la columna monto?

3

Si quieres el promedio de ventas por cliente, ¿qué función debe usarse?

4

Para encontrar el monto mínimo por producto en cada categoría, ¿qué función se usa?

5

¿Qué función te da el valor máximo de ventas por mes?

6

¿Qué diferencia hay entre WHERE y HAVING al filtrar datos agrupados?

7

Si quieres fechas de ventas desde 2024-01-01, ¿qué cláusula usarías?

8

Para mostrar solo los canales con más de 10 ventas, ¿qué cláusula emplearías?

9

Fragmento: SELECT canal, SUM(monto) FROM ventas GROUP BY canal; ¿Qué devuelve?

Explicación

Group by agrupa filas con el mismo canal para aplicar funciones de agregación.

SUM suma los valores; AVG promedia, MIN obtiene el mínimo.

AVG devuelve el promedio; agrégalo por cliente_id para promediar por cliente.

MIN devuelve el valor mínimo dentro de cada grupo.

MAX devuelve el máximo dentro de cada grupo.

WHERE actúa antes de GROUP BY; HAVING se aplica tras agrupar.

WHERE filtra filas antes de cualquier agrupación.

HAVING filtra grupos; COUNT(*) cuenta filas dentro de cada grupo.

Agrupa por canal y suma montos.

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.