I suck at sniping... Um, I mean, here's another video of some of the missions you'll be put through in Missions mode.
