Victoria Becu

Use aggregate functions in query

Returning the average value from a numeric column, represented by year_released. AS referring to an alias.

• December 17, 2016 at 4:11 PM
• Visible to public

SELECT COUNT(*)
FROM people

SELECT AVG(year_released) as average_us_year
FROM movies
WHERE country = 'us'

SELECT MIN(year_released) as earliest_year
FROM movies

SELECT MAX(year_released) as latest_year
FROM movies