CREATE TABLE table_180802_2 (abbr VARCHAR2, zodiac_sign VARCHAR2)

What's the abbreviation of the month in the zodiac sign scorpio?
SELECT abbr FROM table_180802_2 WHERE zodiac_sign = "Scorpio"
SELECT "abbr" FROM "table_180802_2" WHERE "Scorpio" = "zodiac_sign"