Practice Using Joins

Write queries to answer the astronomy questions in Practice 5 and 6. Use the Schema Browser when you need it. (Note: these queries will probably take the full 90 seconds to execute... just let them run until you see the results.)

Practice 5. How can you look up image data, plates and spectra of moderately bright nearby galaxies?

Write a query to find galaxies for which we have spectra that have g magnitude between 17 and 17.4 and redshift less than 0.05. 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.

Answer

Format

HTML

XML

CSV

Enter your SQL query in the text box. The query is limited to 10 minutes and 100,000 rows.

SQL Tutorial



Back to Help
1. Introduction
2. A Simple Query
Practice
3. Common Searches
4. More Samples
Practice
5. Multiple Tables
Practice
6. Aggregate Fcns.
7. Group By
8. Order By
Practice
9. Views
10. Functions
Practice
11. Conclusion