The story of Scorpio:

The sign of Scorpio stems from the Tale of Orion (the legendary Greek hunter). Orion was the son of Poseidon and Euryale. Orion was also a favored hunting partner by Artemis which made her brother Apollo very envious. Apollo pleaded to Gaea to create a giant scorpion to kill Orion. Gaea obliged, and the scorpion stung and killed great Orion. In rememberance of this struggle, Zeus placed Orion and the scorpion amongst the stars.