I think the question is not ready to be published. Description is not clear and have many mistakes like mentioned term "SalesGoal" but I did not find it anywhere 😀

Next is

> Sales value for User Easy does NOT appear in the results

According to the task' explanation that sounds like

"SELECT UserId,UserName,LEAD (Sales,1) OVER (ORDER BY Sales) sales FROM #Users1 ORDER BY SALES"

field sales for user "Easy" will have value = 100. It is obvious and I've got this result.

I've got a question why do choice "Sales value for User Easy does NOT appear in the results," considered as correct part of answer ?!

I would like to get point back.....