SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table MOCK_DATA (
	id INT,
	course_name VARCHAR(150),
	number_member INT,
	date_create VARCHAR(50),
	iduser_create INT,
	date_update VARCHAR(50),
	iduser_update INT
);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (1, 'First Trust South Korea AlphaDEX Fund', 97, '02/01/2022', 1, '08/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (2, 'Public Storage', 13, '04/12/2021', 1, '31/01/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (3, 'Internet Gold Golden Lines Ltd.', 65, '19/09/2021', 1, '21/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (4, 'iShares S&P Emerging Markets Infrastructure Index Fund', 54, '08/08/2021', 1, '19/09/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (5, 'WD-40 Company', 49, '26/06/2021', 1, '15/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (6, 'Fidelity Southern Corporation', 96, '13/02/2022', 1, '28/06/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (7, 'JinkoSolar Holding Company Limited', 33, '21/08/2021', 1, '11/11/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (8, 'First Trust South Korea AlphaDEX Fund', 52, '16/09/2021', 1, '18/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (9, 'Seaspan Corporation', 54, '20/06/2021', 1, '01/08/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (10, 'Cincinnati Financial Corporation', 16, '16/08/2021', 1, '08/01/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (11, 'KAR Auction Services, Inc', 25, '29/12/2021', 1, '08/07/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (12, 'Panera Bread Company', 8, '10/05/2022', 1, '18/04/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (13, 'Ingevity Corporation', 24, '10/03/2022', 1, '27/11/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (14, 'WD-40 Company', 77, '14/06/2022', 1, '09/01/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (15, 'Howard Hughes Corporation (The)', 76, '13/01/2022', 1, '22/05/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (16, 'Invesco Senior Income Trust', 24, '26/01/2022', 1, '22/02/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (17, 'KAR Auction Services, Inc', 10, '28/01/2022', 1, '08/04/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (18, 'Colfax Corporation', 16, '08/06/2022', 1, '16/11/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (19, 'Cempra, Inc.', 18, '15/08/2021', 1, '13/05/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (20, 'Federated National Holding Company', 13, '03/10/2021', 1, '26/01/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (21, 'Gibraltar Industries, Inc.', 18, '07/08/2021', 1, '09/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (22, 'Fidelity Southern Corporation', 70, '28/03/2022', 1, '29/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (23, 'Fidelity Southern Corporation', 68, '15/05/2022', 1, '30/04/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (24, 'KAR Auction Services, Inc', 93, '27/09/2021', 1, '07/05/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (25, 'ArcelorMittal', 26, '13/09/2021', 1, '31/03/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (26, 'Cracker Barrel Old Country Store, Inc.', 15, '28/06/2021', 1, '21/10/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (27, 'Five Prime Therapeutics, Inc.', 98, '17/09/2021', 1, '15/08/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (28, 'Advantage Oil & Gas Ltd', 39, '10/06/2022', 1, '01/11/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (29, 'The Rubicon Project, Inc.', 3, '10/02/2022', 1, '30/03/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (30, 'CVD Equipment Corporation', 28, '18/09/2021', 1, '10/01/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (31, 'The Rubicon Project, Inc.', 62, '03/11/2021', 1, '24/02/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (32, 'Patriot National Bancorp Inc.', 97, '24/06/2021', 1, '11/01/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (33, 'The Rubicon Project, Inc.', 8, '28/03/2022', 1, '01/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (34, 'Resolute Forest Products Inc.', 90, '06/08/2021', 1, '22/03/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (35, 'First Trust South Korea AlphaDEX Fund', 10, '03/04/2022', 1, '18/05/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (36, 'The Rubicon Project, Inc.', 24, '28/06/2021', 1, '29/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (37, 'AvalonBay Communities, Inc.', 34, '15/10/2021', 1, '16/09/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (38, 'Tiffany & Co.', 1, '14/02/2022', 1, '08/09/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (39, 'Affiliated Managers Group, Inc.', 88, '01/02/2022', 1, '19/12/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (40, 'National Research Corporation', 46, '19/08/2021', 1, '26/09/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (41, 'Discover Financial Services', 94, '12/11/2021', 1, '14/04/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (42, 'DENTSPLY SIRONA Inc.', 68, '14/10/2021', 1, '06/08/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (43, 'Communications Systems, Inc.', 100, '01/06/2022', 1, '06/08/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (44, 'Pacific Drilling S.A.', 96, '25/01/2022', 1, '02/04/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (45, 'Oil States International, Inc.', 36, '01/05/2022', 1, '30/10/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (46, 'Embraer-Empresa Brasileira de Aeronautica', 59, '30/11/2021', 1, '13/02/2023', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (47, 'SL Green Realty Corporation', 10, '09/04/2022', 1, '09/07/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (48, 'Southwestern Energy Company', 30, '07/11/2021', 1, '22/11/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (49, 'Pimco Global Stocksplus & Income Fund', 52, '05/12/2021', 1, '14/08/2022', 1);
insert into MOCK_DATA (id, course_name, number_member, date_create, iduser_create, date_update, iduser_update) values (50, 'Juniper Networks, Inc.', 72, '19/12/2021', 1, '12/04/2023', 1);
50 rows affected

SELECT TOP(20) id, course_name, number_member,date_update 
       FROM MOCK_DATA 
       GROUP BY id, course_name, number_member,date_update 
       ORDER BY number_member DESC


id
course_name
number_member
date_update


43
Communications Systems, Inc.
100
06/08/2022

27
Five Prime Therapeutics, Inc.
98
15/08/2022

1
First Trust South Korea AlphaDEX Fund
97
08/12/2022

32
Patriot National Bancorp Inc.
97
11/01/2023

6
Fidelity Southern Corporation
96
28/06/2022

44
Pacific Drilling S.A.
96
02/04/2023

41
Discover Financial Services
94
14/04/2023

24
KAR Auction Services, Inc
93
07/05/2023

34
Resolute Forest Products Inc.
90
22/03/2023

39
Affiliated Managers Group, Inc.
88
19/12/2022

14
WD-40 Company
77
09/01/2023

15
Howard Hughes Corporation (The)
76
22/05/2023

50
Juniper Networks, Inc.
72
12/04/2023

22
Fidelity Southern Corporation
70
29/12/2022

23
Fidelity Southern Corporation
68
30/04/2023

42
DENTSPLY SIRONA Inc.
68
06/08/2022

3
Internet Gold Golden Lines Ltd.
65
21/12/2022

31
The Rubicon Project, Inc.
62
24/02/2023

46
Embraer-Empresa Brasileira de Aeronautica
59
13/02/2023

4
iShares S&P Emerging Markets Infrastructure Index Fund
54
19/09/2022


SELECT TOP(20) id, course_name, number_member, date_update
FROM MOCK_DATA MG
WHERE number_member = (SELECT MAX(number_member) FROM MOCK_DATA WHERE course_name=MG.course_name)
ORDER BY number_member DESC


id
course_name
number_member
date_update


43
Communications Systems, Inc.
100
06/08/2022

27
Five Prime Therapeutics, Inc.
98
15/08/2022

32
Patriot National Bancorp Inc.
97
11/01/2023

1
First Trust South Korea AlphaDEX Fund
97
08/12/2022

44
Pacific Drilling S.A.
96
02/04/2023

6
Fidelity Southern Corporation
96
28/06/2022

41
Discover Financial Services
94
14/04/2023

24
KAR Auction Services, Inc
93
07/05/2023

34
Resolute Forest Products Inc.
90
22/03/2023

39
Affiliated Managers Group, Inc.
88
19/12/2022

14
WD-40 Company
77
09/01/2023

15
Howard Hughes Corporation (The)
76
22/05/2023

50
Juniper Networks, Inc.
72
12/04/2023

42
DENTSPLY SIRONA Inc.
68
06/08/2022

3
Internet Gold Golden Lines Ltd.
65
21/12/2022

31
The Rubicon Project, Inc.
62
24/02/2023

46
Embraer-Empresa Brasileira de Aeronautica
59
13/02/2023

4
iShares S&P Emerging Markets Infrastructure Index Fund
54
19/09/2022

9
Seaspan Corporation
54
01/08/2022

49
Pimco Global Stocksplus & Income Fund
52
14/08/2022
id	course_name	number_member	date_update
43	Communications Systems, Inc.	100	06/08/2022
27	Five Prime Therapeutics, Inc.	98	15/08/2022
1	First Trust South Korea AlphaDEX Fund	97	08/12/2022
32	Patriot National Bancorp Inc.	97	11/01/2023
6	Fidelity Southern Corporation	96	28/06/2022
44	Pacific Drilling S.A.	96	02/04/2023
41	Discover Financial Services	94	14/04/2023
24	KAR Auction Services, Inc	93	07/05/2023
34	Resolute Forest Products Inc.	90	22/03/2023
39	Affiliated Managers Group, Inc.	88	19/12/2022
14	WD-40 Company	77	09/01/2023
15	Howard Hughes Corporation (The)	76	22/05/2023
50	Juniper Networks, Inc.	72	12/04/2023
22	Fidelity Southern Corporation	70	29/12/2022
23	Fidelity Southern Corporation	68	30/04/2023
42	DENTSPLY SIRONA Inc.	68	06/08/2022
3	Internet Gold Golden Lines Ltd.	65	21/12/2022
31	The Rubicon Project, Inc.	62	24/02/2023
46	Embraer-Empresa Brasileira de Aeronautica	59	13/02/2023
4	iShares S&P Emerging Markets Infrastructure Index Fund	54	19/09/2022