You don't add a table. You join the table to itself, and when you do this you have to give the second instance a new name or alias so SQL Server can tell which of the two instances you are referring to. In the example I gave, your table is named Members, and when I join it in for the second time I give it the alias MembersCount.
If it's not practically useful, then it's practically useless.
SELECT l.LastName+', '+l.FirstName, COUNT(*) AS ArtificialOrder
FROM Employees l INNER JOIN Employees r ON l.LastName+', '+l.FirstName >= r.LastName+', '+r.FirstName
GROUP BY l.LastName+', '+l.FirstName
ORDER BY 2
Understand though, the order of data in a database is inconsequential...