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
8. Task 5

Instruction

David has spent most of his time studying about his favorite constellations: Hydra, Virgo, Ursa Major, Cetus, and Hercules. (In our database, these constellations have the IDs 1, 2, 3, 4, and 5.)

Exercise

Use the database to find the names and absolute magnitudes of stars in these constellations (of ID 1, 2, 3, 4, or 5) – but only for these stars with an absolute magnitude lower than the apparent magnitude of any star in the database.

Select the names (name) and absolute magnitudes (absolute_magnitude) of the stars that meet the given conditions.