By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
create table members (id int, first_name varchar(20), last_name varchar(20));
insert into members values (7,'G.', 'Williams');
insert into members values (13,'M.', 'Williams');
insert into members values (20,'T.', 'Williams');
insert into members values (8,'H.', 'Williams');
insert into members values (24,'X.', 'Williams');
insert into members values (21,'U.', 'Williams');
insert into members values (9,'I.', 'Williams');
insert into members values (16,'P.', 'Williams');
insert into members values (26,'Z.', 'Williams');
insert into members values (19,'S.', 'Williams');
insert into members values (6,'F.', 'Williams');
insert into members values (2,'B.', 'Williams');
insert into members values (15,'O.', 'Williams');
insert into members values (12,'L.', 'Williams');
insert into members values (1,'A.', 'Williams');
insert into members values (3,'C.', 'Williams');
insert into members values (23,'W.', 'Williams');
insert into members values (25,'Y.', 'Williams');
insert into members values (17,'Q.', 'Williams');
insert into members values (22,'V.', 'Williams');
insert into members values (4,'D.', 'Williams');
insert into members values (10,'J.', 'Williams');
insert into members values (18,'R.', 'Williams');
insert into members values (5,'E.', 'Williams');
insert into members values (14,'N.', 'Williams');
insert into members values (11,'K.', 'Williams');
select * from members;
| version() |
|---|
| 5.7.35 |
| id | first_name | last_name |
|---|---|---|
| 7 | G. | Williams |
| 13 | M. | Williams |
| 20 | T. | Williams |
| 8 | H. | Williams |
| 24 | X. | Williams |
| 21 | U. | Williams |
| 9 | I. | Williams |
| 16 | P. | Williams |
| 26 | Z. | Williams |
| 19 | S. | Williams |
| 6 | F. | Williams |
| 2 | B. | Williams |
| 15 | O. | Williams |
| 12 | L. | Williams |
| 1 | A. | Williams |
| 3 | C. | Williams |
| 23 | W. | Williams |
| 25 | Y. | Williams |
| 17 | Q. | Williams |
| 22 | V. | Williams |
| 4 | D. | Williams |
| 10 | J. | Williams |
| 18 | R. | Williams |
| 5 | E. | Williams |
| 14 | N. | Williams |
| 11 | K. | Williams |
SELECT GROUP_CONCAT(CONCAT(members.first_name,' ',members.last_name) SEPARATOR ' & ') team
FROM members
| team |
|---|
| G. Williams & M. Williams & T. Williams & H. Williams & X. Williams & U. Williams & I. Williams & P. Williams & Z. Williams & S. Williams & F. Williams & B. Williams & O. Williams & L. Williams & A. Williams & C. Williams & W. Williams & Y. Williams & Q. Williams & V. Williams & D. Williams & J. Williams & R. Williams & E. Williams & N. Williams & K. Williams |
SELECT GROUP_CONCAT(CONCAT(members.first_name,' ',members.last_name) ORDER BY first_name SEPARATOR ' & ') team
FROM members
| team |
|---|
| A. Williams & B. Williams & C. Williams & D. Williams & E. Williams & F. Williams & G. Williams & H. Williams & I. Williams & J. Williams & K. Williams & L. Williams & M. Williams & N. Williams & O. Williams & P. Williams & Q. Williams & R. Williams & S. Williams & T. Williams & U. Williams & V. Williams & W. Williams & X. Williams & Y. Williams & Z. Williams |
SELECT GROUP_CONCAT(CONCAT(members.first_name,' ',members.last_name) ORDER BY first_name DESC SEPARATOR ' & ') team
FROM members
| team |
|---|
| Z. Williams & Y. Williams & X. Williams & W. Williams & V. Williams & U. Williams & T. Williams & S. Williams & R. Williams & Q. Williams & P. Williams & O. Williams & N. Williams & M. Williams & L. Williams & K. Williams & J. Williams & I. Williams & H. Williams & G. Williams & F. Williams & E. Williams & D. Williams & C. Williams & B. Williams & A. Williams |