Practice 2. Which of the objects you found in
Practice 1 are galaxies?
Open the
Schema Browser. Click on views and select SpecObj.
You will see a list of all the columns in the SpecObj
table, along with short descriptions of what they mean and
if applpicable, what values the column may have. For instance,
if you scroll down to the "class" column, its description says
that it may have one of the following values: 'STAR',
'GALAXY', or 'QSO'.
Modify your query so that it returns the ra, dec, and best
object ID for galaxies (and only galaxies) whose ra is
between 140.25 and 140.75 and whose dec is between 20.25 and 20.75.
|