MySQL 5.7

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

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