Scorpion tail on mammalian body

Manticore

a lion's body, and a scorpion's tail

Centicore

Adding to its fearsome arsenal is the Centicore's scorpion-like tail, a long, segmented appendage that ends in a venomous stinger.

Pazuzu

a canine or leonine face with bulging eyes, a scaly body, a scorpion's tail, talons on both his hands and feet, and two pairs of wings

Tarasque

The Tarasque is said to have six bear-like legs, ending in powerful claws, and a long, serpentine tail tipped with a scorpion's stinger.