SQLite 3.27

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

CREATE TABLE student (`id` INTEGER, `name` VARCHAR(6), `gender` VARCHAR(10), `age` INTEGER);
INSERT INTO student VALUES
  ('1', 'Jolly', 'Female', '20'),
  ('2', 'Jon', 'Male', '22'),
  ('3', 'Sara', 'Female', '25'),
  ('4', 'Laura', 'Female', '18'),
  ('5', 'Alan', 'Male', '20'),
  ('6', 'Kate', 'Female', '22'),
  ('7', 'Joseph', 'Male', '18'),
  ('8', 'Mice', 'Male', '23'),
  ('9', 'Wise', 'Male', '21'),
  ('10', 'Elis', 'Female', '27');
SELECT name, age, 
       (SELECT 100 * AVG(age > 22) FROM student) AS Total_Perecentage 
FROM student 
WHERE age > 22


name
age
Total_Perecentage


Sara
25
30

Mice
23
30

Elis
27
30