SNP's Stephen Flynn wins Aberdeen seat in Holyrood election

The party's Westminster leader will have to resign from the UK Parliament to take up his place at Holyrood.