Change the SELECT and the separator to obtain last and first names:
SELECT lname||', '||fname FROM names ORDER BY lname;
The result is:
((lname||', ')||fname) ---------------------- Brown, Alan Kanieski, Carol Ryan, Loretta Villegas, Arnando
Change the SELECT and the separator to obtain last and first names:
SELECT lname||', '||fname FROM names ORDER BY lname;
The result is:
((lname||', ')||fname) ---------------------- Brown, Alan Kanieski, Carol Ryan, Loretta Villegas, Arnando