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
7. Task 4

Instruction

January is one of David's favorite months for stargazing. Today, he's looking for the brightest star and wants to know which stars are the brightest – but only for constellations with an area greater than 1,000.

Exercise

Select the name(s) of the brightest star(s) in constellations with an area over 1,000. Show the star name (as star_name) and the constellation name (as constellation_name).

Remember that the brighter a star appears from Earth, the lower its apparent magnitude. (In the star table, the name of the column is apparent_magnitude.)