CREATE TABLE table_1820752_1 (spectral_type VARCHAR2, constellation VARCHAR2)

If the constellation is Gemini, what is the spectral type?
SELECT spectral_type FROM table_1820752_1 WHERE constellation = "Gemini"
SELECT "spectral_type" FROM "table_1820752_1" WHERE "Gemini" = "constellation"