select ra, dec, parallax, phot_g_mean_mag, phot_bp_mean_mag, phot_rp_mean_mag 
   from gaiadr3.gaia_source_lite
   where parallax > 200 and phot_g_mean_mag < 15
;

    yields 48 stars
           gaia_query_200.csv




select ra, dec, parallax, phot_g_mean_mag, phot_bp_mean_mag, phot_rp_mean_mag 
   from gaiadr3.gaia_source_lite
   where parallax > 50 and phot_g_mean_mag < 15
;

    yields 2226 stars
           gaia_query_50.csv




select ra, dec, parallax, phot_g_mean_mag, phot_bp_mean_mag, phot_rp_mean_mag 
   from gaiadr3.gaia_source_lite
   where parallax > 20 and phot_g_mean_mag < 15
;

    yields 28957 stars   (finally see a small giant branch, limited extent)
           gaia_query_20.csv





select ra, dec, parallax, phot_g_mean_mag, phot_bp_mean_mag, phot_rp_mean_mag 
   from gaiadr3.gaia_source_lite
   where parallax > 10 and phot_g_mean_mag < 15
;

    yields 154425 stars   (giant branch grows, red clump appears)
           gaia_query_10.csv



select ra, dec, parallax, phot_g_mean_mag, phot_bp_mean_mag, phot_rp_mean_mag 
   from gaiadr3.gaia_source_lite
   where parallax > 5 and phot_g_mean_mag < 15
;

    yields 699935 stars   (giant branch extends to red supergiants)
           gaia_query_5.csv




--------------------------------------------------------------------------

 Homework: Run a new query to find all stars which lie within 10 pc of 
            the Sun, and which have "g" magnitudes brighter than 15. 

     select ra, dec, parallax, parallax_over_error, phot_g_mean_mag, bp_rp 
       from gaiadr3.gaia_source_lite
       where  parallax > 100   and  phot_g_mean_mag < 15
     ;

               --> gaia_query_a.csv

        1. yields  284  stars