|
Unfortunately, I don't know SQL well enough to answer your literal question (but cliche looks like he's onto something) but let me ask you an obvious question.
Is there a particular reason why first name and surname don't have their own columns? Usually, this is the case and, in this case, sorting by surname is easy.
Is this difficulty, in fact, part of the assignment?
|