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

GROUP BY Extensions in PostgreSQL

Introduction
Quiz
6. Question 4
The End

Instruction

Good job. Two more questions to go!

Exercise

Find the minimum fuel consumption per 100 km for all grouping combinations involving the year, country, and car_size columns.

Show the following columns in the query result: year, country, car_size, y, c, cs showing if the columns year, country, car_size, respectively, is included in the grouping, and min_fuel_consumption.

To calculate fuel consumption per 100 km, divide fuel_consumed by distance, and multiply the result by 100.

Stuck? Here's a hint!

To calculate min_fuel_consumption, use the following:

MIN((fuel_consumed/distance)*100) AS min_fuel_consumption