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

SQL Coding Challenge – January 2020

Introduction
Resolve tasks and learn about the cosmos
9. Task 6

Instruction

Each star has a very high temperature, which in astronomy we measure with the Kelvin scale. (This scale uses kelvins (K) as a temperature unit, not degrees.) David is going to review his data about star temperatures.

Exercise

From our database, find the highest average star temperature per constellation. Name the column highest_average. You should first calculate the average star temperature in each constellation, then find the highest among them.