Scorpion fly, gemeine Skorpionsfliege

this insect was about 2-3 cm long, has black spots on the tip of the wings, and a quite interesting scorpion-like stinging tail. there also is a yellow ring on the thorax.