MySQL 8.0

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')
select distinct * from demo


name
gender


dragonH
Male

dragonH
Female

Leo
Male

Leo
Female


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


name
gender
count(*)


dragonH
Male
6

dragonH
Female
3

Leo
Male
6

Leo
Female
3


create table demo1 (
  name varchar(50),
  gender varchar(50),
  json_data JSON
)
insert into demo1 (name, gender, json_data) values
('dragonH', 'Male', '{ "gender": "Male"}'),
('dragonH', 'Female', '{ "gender": "Female"}'),
('Leo', 'Male', '{ "gender": "Male"}'),
('Leo', 'Female', '{ "gender": "Feale"}'),
('dragonH', 'Male', '{ "gender": "Male"}'),
('dragonH', 'Female', '{ "gender": "Female"}'),
('Leo', 'Male', '{ "gender": "Male"}'),
('Leo', 'Female', '{ "gender": "Feale"}'),
('dragonH', 'Male', '{ "gender": "Male"}'),
('Leo', 'Male', '{ "gender": "Male"}'),
('Leo', 'Female', '{ "gender": "Feale"}'),
('dragonH', 'Male', '{ "gender": "Male"}'),
('dragonH', 'Female', '{ "test": "1", "gender": "Female"}'),
('dragonH', 'Female', '{ "gender": "Female", "test": "1"}'),
('Leo', 'Male', '{ "gender": "Male"}'),
('Leo', 'Female', '{ "gender": "Feale"}')
select distinct * from demo1


name
gender
json_data


dragonH
Male
{"gender": "Male"}

dragonH
Female
{"gender": "Female"}

Leo
Male
{"gender": "Male"}

Leo
Female
{"gender": "Feale"}

dragonH
Female
{"test": "1", "gender": "Female"}


select *, count(*) from demo1 group by name, gender,json_data


name
gender
json_data
count(*)


dragonH
Male
{"gender": "Male"}
4

dragonH
Female
{"gender": "Female"}
2

Leo
Male
{"gender": "Male"}
4

Leo
Female
{"gender": "Feale"}
4

dragonH
Female
{"test": "1", "gender": "Female"}
2

name	gender	json_data
dragonH	Male	{"gender": "Male"}
dragonH	Female	{"gender": "Female"}
Leo	Male	{"gender": "Male"}
Leo	Female	{"gender": "Feale"}
dragonH	Female	{"test": "1", "gender": "Female"}