Hey Ron, There seems to be some confustion with answer choices here. When we have ORDER BY caluse on Sales, it will order the results in the following fashion:

UserId UserName Sales

----------- -------- ---------------------------------------

6 Easy 50.00

1 Joe 100.00

3 Charlie 400.00

2 Baker 700.00

4 Able 800.00

5 XRay 1000.00

Now when we apply LEAD function over this, XRay will have NULL value not EASY as mentioned in the ansewer choices.

Please verify!