Nicola Sturgeon resigns