• I always get the order of these two confused, because it's one of the places where SQL diverges from English.
    In English, DISTINCT TOP 5 would mean "get the distinct values of the top five results" -- which with this data set would return only one row (1), whereas TOP 5 DISTINCT clearly means "get the top 5 values of the distinct results."
    SQL uses the first syntax, but to mean the second instruction.