Alex Cole-Hamilton has accused the SNP of “allowing the north-east to drift” and not doing the work to ensure a just transition for oil and gas workers.