Do petitions ever work?

More than five million people have signed a petition against Brexit - but do petitions ever work?