Celestia Forums

A taste of what im working on.


SELECT hip,hd,RA,declination,parallax,absoluteMagnitude,parallaxError,starType,spectralClass,spectralSubClass,luminosityClass FROM star WHERE (declination > 70 AND distFromSol>170 AND distFromSol<500) OR HIP = 0










SELECT hip,hd,RA,declination,parallax,absoluteMagnitude,parallaxError,starType,spectralClass,spectralSubClass,luminosityClass FROM star WHERE (declination > 80) OR HIP = 0




And finally all the stars that have a planet with a breathable atmosphere.
SELECT hip,hd,RA,declination,parallax,absoluteMagnitude,parallaxError,starType,spectralClass,spectralSubClass,luminosityClass FROM star WHERE breathable > 0 OR HIP = 0




again with every other star