Question: Please help, if anyone can help with this SQL query! Task 1 David has gathered information about 88 constellations. He once heard which constellation has
Task 1 David has gathered information about 88 constellations. He once heard which constellation has the greatest number of main stars, but he's forgotten its name. Let's see if we can find it in the database. Exercise Select the id and name of the constellation with the most main stars. Task 2 David was visited by his best friend, Frank. Frank was delighted to observe the sky and asked David about the constellation Andromeda. He wondered which stars with known masses belong to it. Select all the stars with known masses in the Andromeda constellation Get stars' names and masses and sort them in descending order by mass. Task 3 David knows some constellations have greater area than others. Let's help him find specific info on that
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
