Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
Quiz
8. Exercise 4
Congratulations

Instruction

Great! Let’s move on to an exercise with another aggregate function.

Exercise

The preparation of recipes takes some time. Find the shortest and longest cooking times. In the result table, display the shortest cooking time (name column as min_time), and the longest cooking time (name column as max_time).

Stuck? Here's a hint!

Use MIN and MAX functions. If you don’t remember these aggregate functions, look at our SQL Basics course, Part 4: Aggregation and grouping.