MySQL 8.0

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

CREATE TABLE temp (type VARCHAR(10), duration_type VARCHAR(20));
INSERT INTO temp VALUES
  ('member', 'duration_type1'), ('member', 'duration_type1'), ('member', 'duration_type2'), 
  ('member', 'duration_type3'), ('member', 'duration_type3'), ('member', 'duration_type3'), 
  ('casual', 'duration_type1'), ('casual', 'duration_type1'), ('casual', 'duration_type1'), 
  ('casual', 'duration_type2'), ('casual', 'duration_type2');
SELECT type, duration_type,
       CONCAT(ROUND(100.0 * COUNT(*) / SUM(COUNT(*)) OVER (PARTITION BY type), 2), '%') AS per
FROM temp
GROUP BY type, duration_type;


type
duration_type
per


casual
duration_type1
60.00%

casual
duration_type2
40.00%

member
duration_type1
33.33%

member
duration_type2
16.67%

member
duration_type3
50.00%


SELECT t1.type, t1.duration_type,
       CONCAT(ROUND(100.0 * COUNT(*) / (SELECT COUNT(*) FROM temp t2 WHERE t2.type = t1.type), 2), '%') AS per
FROM temp t1
GROUP BY t1.type, t1.duration_type;


type
duration_type
per


member
duration_type1
33.33%

member
duration_type2
16.67%

member
duration_type3
50.00%

casual
duration_type1
60.00%

casual
duration_type2
40.00%

type	duration_type	per
casual	duration_type1	60.00%
casual	duration_type2	40.00%
member	duration_type1	33.33%
member	duration_type2	16.67%
member	duration_type3	50.00%