उपसमूहों का सारांश

इंटरमीडिएट SQL

Jasmin Ludolf

Data Science Content Developer, DataCamp

एग्रीगेट फंक्शन के साथ WHERE का उपयोग

SELECT AVG(budget) AS avg_budget
FROM films
WHERE release_year >= 2010;

|avg_budget          |
|--------------------|
|41072235.18324607...|

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     |

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         |

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|

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  |

SELECT ROUND(AVG(budget), -5) AS avg_budget
FROM films
WHERE release_year >= 2010;

|avg_budget|
|----------|
|41100000  |

इंटरमीडिएट SQL