Over the years, major companies like BP and Shell have invested there. As a result, Aberdeen has more millionaires per capita than London. But now fortunes are changing and people are worried about their jobs.