MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employee (
  id TINYINT NOT NULL AUTO_INCREMENT,
  first_name VARCHAR(65),
  last_name VARCHAR(65),
  PRIMARY KEY(id)
) ;
INSERT INTO employee (first_name,last_name) 
  VALUES 
  ('John','Doe'), 
  ('Jane','Doe'),
  ('Michael','Jackson'),
  ('Elvis','Presley'),
  ('Freddie','Mercury') ;

Records: 5  Duplicates: 0  Warnings: 0


SELECT * FROM employee;


id
first_name
last_name


1
John
Doe

2
Jane
Doe

3
Michael
Jackson

4
Elvis
Presley

5
Freddie
Mercury


WITH 
  a AS
  ( SELECT 
        last_name,
        ROW_NUMBER() OVER (ORDER BY last_name) AS rn
    FROM employee 
  ),
  d AS
  ( SELECT 
        last_name,
        ROW_NUMBER() OVER (ORDER BY last_name DESC) AS rn
    FROM employee 
)
SELECT
    a.last_name AS last_name_a,
    d.last_name AS last_name_d
FROM a JOIN d USING (rn) ;


last_name_a
last_name_d


Doe
Presley

Doe
Mercury

Jackson
Jackson

Mercury
Doe

Presley
Doe