SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table demo (
  name varchar(50),
  gender varchar(50)
)
insert into demo (name, gender) values
('dragonH', 'Male'),
('dragonH', 'Female'),
('Leo', 'Male'),
('Leo', 'Female'),
('dragonH', 'Male'),
('Leo', 'Male'),
('dragonH', 'Male'),
('dragonH', 'Female'),
('Leo', 'Male'),
('Leo', 'Female'),
('dragonH', 'Male'),
('Leo', 'Male'),
('dragonH', 'Male'),
('dragonH', 'Female'),
('Leo', 'Male'),
('Leo', 'Female'),
('dragonH', 'Male'),
('Leo', 'Male')
18 rows affected

select * from demo


name
gender


dragonH
Male

dragonH
Female

Leo
Male

Leo
Female

dragonH
Male

Leo
Male

dragonH
Male

dragonH
Female

Leo
Male

Leo
Female

dragonH
Male

Leo
Male

dragonH
Male

dragonH
Female

Leo
Male

Leo
Female

dragonH
Male

Leo
Male


select *, count(*) from demo group by name, gender


name
gender
(No column name)


dragonH
Female
3

Leo
Female
3

dragonH
Male
6

Leo
Male
6

name	gender
dragonH	Male
dragonH	Female
Leo	Male
Leo	Female
dragonH	Male
Leo	Male
dragonH	Male
dragonH	Female
Leo	Male
Leo	Female
dragonH	Male
Leo	Male
dragonH	Male
dragonH	Female
Leo	Male
Leo	Female
dragonH	Male
Leo	Male