Hi, there is a mistake in the 'Stairway to T-SQL DML Level 6: The Basics of Sorting Data Using the ORDER BY Clause' - I'm sure this is as a result of a re-edit since 8000 people have read the article already.
The code in Listing 2 has an
ORDER BY Car.Make ASC;
but underneath the results it states
Report 1: Output when ordering by Car.Make
Notice that I didn’t specify the ASC or DESC in my ORDER BY specification. By not specifying the sort direction, SQL Server will sort in ascending (ASC) order.