MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.36


CREATE TABLE mytable ( 
id VARCHAR(20) ,
name VARCHAR(20) ,
gender VARCHAR(20) ,
image VARCHAR(20) ,
browser VARCHAR(20) ,
os VARCHAR(20) );

INSERT INTO  mytable  VALUES
('1','chris','male','1','0','ios'),
('2','emma','female','1','1','ios'),
('3','james','male','0','0','android'),
('4','lucas','male','1','0','android'),
('5','amelia','female','0','1','ios'),
('6','olivia','female','1','0','ios');


Records: 6  Duplicates: 0  Warnings: 0


SELECT *
FROM (
   SELECT 'name' col, name, count(*) c FROM mytable WHERE gender = 'male' group by name union all
   SELECT 'gender', gender, count(*) c FROM mytable WHERE gender = 'male' group by gender union all
   SELECT 'image', image, count(*) c FROM mytable WHERE gender = 'male' group by image union all
   SELECT 'browser', browser, count(*) c FROM mytable WHERE gender = 'male' group by browser union all
   SELECT 'os', os, count(*) c FROM mytable WHERE gender = 'male' group by os 
   
) x
WHERE x.c = (SELECT count(*) FROM mytable WHERE gender = 'male');
;


col
name
c


gender
male
3

browser
0
3


SELECT *
FROM (
   SELECT 'name' col, name, count(*) c FROM mytable WHERE gender = 'female' group by name union all
   SELECT 'gender', gender, count(*) c FROM mytable WHERE gender = 'female' group by gender union all
   SELECT 'image', image, count(*) c FROM mytable WHERE gender = 'female' group by image union all
   SELECT 'browser', browser, count(*) c FROM mytable WHERE gender = 'female' group by browser union all
   SELECT 'os', os, count(*) c FROM mytable WHERE gender = 'female' group by os 
   
) x
WHERE x.c = (SELECT count(*) FROM mytable WHERE gender = 'female');
;


col
name
c


gender
female
3

os
ios
3