Practice Using Joins
Write queries to answer the astronomy questions in Practice 5 and 6.
Use the Object
Browser when you need it.
|
Practice 5. How can you look up image data, plates and spectra
of galaxies with declination between 0 and 2?
Write a query to find
galaxies for which we have spectra that have a dec between 0 and 2.
For each galaxy, retrieve the object ID, the five magnitudes (u,g,r,i,z), the redshift,
the plate/MJD number, and the fiber number.
|
|
Practice 6. What types (templates) of
quasars have high redshifts?
Write a query to find the
template number matched to all high redshift quasars (redshift
greater than 2.5).
HINT: template number is in the Cross-Correlation Redshifts table.
Retrieve the objects' ra, dec, u, g, r, i, z, redshift, and tempno. |
Answers
 |
The query you just submitted may take up to 90 seconds.
Please wait until it finishes...
|
|
