Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in PostgreSQL

Introduction
Quiz
8. Exercise 4
Congratulations

Instruction

Great! Let's move on another aggregate function.

Exercise

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

Stuck? Here's a hint!

Use the MIN and MAX functions. If you don't remember these aggregate functions, look at Basics of PostgreSQL Part 4: Aggregation and grouping.