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
