Levelup

🕵️‍♀️ Task

Calculate the average duration for a record from the movies table

movies

You can calculate the average value in a particular column within a collection with .average. It returns a single value (Integer or Float).

id	title	year	duration	description	image	director_id

id	name	dob	bio	image

id	name	dob	bio	image

id	actor_id	movie_id	name
689	625	48	Man Waiting to Cross
690	626	48	Street Musician (as Lucie S...
691	627	48	Street Musician
692	628	48	Street Musician
693	180	49	Billy
694	480	49	Colin Sullivan
695	585	49	Frank Costello
696	629	49	Dignam

Calculate the average age for all users

User.all.average(:age)
=> 27

Calculate the average price for all dishes

Dish.all.average(:price)
=> 5.69