The yield stress of foamy sands