Strictly speaking that's not true, as it doesn't need ORDER BY CustomerName, as it could have ORDER BY RN instead and achieve the same effect (since RN is in the select list and the prder for the row numbering is specified to be by CustomerName). Being a lazy person, I might actually use ORDER BY RN because typing RN is less effort than typing CustomerName.

I agree or course that all these questions are appalling drivel.