Skip to content

Latest commit

 

History

History
15 lines (8 loc) · 331 Bytes

Aggregate Functions.md

File metadata and controls

15 lines (8 loc) · 331 Bytes

Use the SUM function to get the total duration of all films.

Select sum(duration) from films

Get the duration of the longest film.

Select max (duration) from films

Get the average duration of all films.

Select avg(duration) from films

Get the average amount grossed by all films.

Select avg(gross) from films