Resumir subconjuntos

SQL intermedio

Jasmin Ludolf

Data Science Content Developer, DataCamp

Utilizar WHERE con funciones de agregación

SELECT AVG(budget) AS avg_budget
FROM films
WHERE release_year >= 2010;
|avg_budget          |
|--------------------|
|41072235.18324607...|
SQL intermedio

Utilizar WHERE con funciones de agregación

SELECT SUM(budget) AS sum_budget
FROM films
WHERE release_year = 2010;
|sum_budget|
|----------|
|8942365000|
SELECT MIN(budget) AS min_budget
FROM films
WHERE release_year = 2010;
|min_budget|
|----------|
|65000     |
SQL intermedio

Utilizar WHERE con funciones de agregación

SELECT MAX(budget) AS max_budget
FROM films
WHERE release_year = 2010;
|max_budget|
|----------|
|600000000 |
SELECT COUNT(budget) AS count_budget
FROM films
WHERE release_year = 2010;
|count_budget|
|------------|
|194         |
SQL intermedio

ROUND()

  • Redondea un número a un decimal especificado
SELECT AVG(budget) AS avg_budget
FROM films
WHERE release_year >= 2010;
|avg_budget          |
|--------------------|
|41072235.18324607...|

ROUND(number_to_round, decimal_places)

SELECT ROUND(AVG(budget), 2) AS avg_budget
FROM films
WHERE release_year >= 2010;
|avg_budget |
|-----------|
|41072235.18|
SQL intermedio

ROUND() a un número entero

SELECT ROUND(AVG(budget)) AS avg_budget
FROM films
WHERE release_year >= 2010;
|avg_budget|
|----------|
|41072235  |
SELECT ROUND(AVG(budget), 0) AS avg_budget
FROM films
WHERE release_year >= 2010;
|avg_budget|
|----------|
|41072235  |
SQL intermedio

ROUND() con un parámetro negativo

SELECT ROUND(AVG(budget), -5) AS avg_budget
FROM films
WHERE release_year >= 2010;
|avg_budget|
|----------|
|41100000  |
  • Solo campos numéricos
SQL intermedio

¡Vamos a practicar!

SQL intermedio

Preparing Video For Download...