SELECT concat(
         e.last_name, ' ', 
         e.first_name, ' ', 
         e.middle_name, ';'
       ) AS full_name
  FROM employee e
 ORDER BY full_name