Resolve tasks and learn about the cosmos
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.
