Levelup

🕵️‍♀️ Task

Calculate the highest duration from the movies table

movies

id (integer)
title (string)
year (integer)
duration (integer)
description (text)
image (string)
director_id (integer)

directors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

actors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

characters

id (integer)
actor_id (integer)
movie_id (integer)
name (string)

📖Method

You can calculate the largest/latest value in a particular column within a collection with .maximum. It returns a single value (of whatever datatype the column is).

Calculates the maximum value on a given column. The value is returned with the same data type of the column, or nil if there’s no row. See calculate for examples with options.

Data

id	title	year	duration	description	image	director_id

Data

id	name	dob	bio	image

Data

id	name	dob	bio	image

Data

id	actor_id	movie_id	name
665	601	47	Joshua
666	602	47	Uncle Eliseo
667	603	47	Ferruccio (as Sergio Bustric)
668	604	47	Dora's Mother
669	605	47	Doctor Lessing (as Horst Bu...
670	606	47	School Principal
671	607	47	Rodolfo
672	608	47	Bartolomeo

Examples

Calculate the highest age for all users

User.all.maximum(:age)
=> 53

Calculate the highest price for all dishes

Dish.all.maximum(:price)
=> 21