Longsands Academy, in St Neots, is considered the least “happiest” in the country, an analysis published by The Sunday Times has found.