Existence and non-existence of constant scalar curvature and extremal Sasaki metrics