Tables should be sorted in a way that's useful to the majority of users.
If there are use cases for different sort orders, consider implementing a sortable table.
Sortable tables can be used to assist users in comparing data. Use clear link styles to indicate that the column titles are clickable, and an arrow to indicate the current column being sorted and direction of sort.
When sorting a column, choose a good default sort direction. Eg for'number of applications' users are more likely to be interested in large to small than the reverse.
Unsortable values(eg blank cells or N/A) should appear at the end of the sorted table.[regardless of sort-direction? or only at the end when in descending order?]