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

Please help, if anyone can help with this SQL query! Please help, if anyone can help with this SQL query! Task 1

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!