Questions about getting nose piercing?

I really want to get my nose pierced. I see people with the studs in their nose and it just looks so cute! So does it hurt?? What kind of stud is the best? How much does it cost and where should I go to get it? What happens when you're sick with a cold and you blow your nose?? Haha sorry just wondering thanks to whoever answers!