I need to make Function+having by sql depinding in the information in the picture.

Create database Gym; show databases; use Gym; Create table consumer (cons_id int primary key, phone_number int(10)not null, length int, age int, consumer_name varchar(20)not null, weight char); Create table Payment (Pay_ID int primary key, date_train date, price int, Paayment_type char(15),cons_id int foreign key references consumer (cons_id)); Create table training_plan (plan_ID int primary key, time int, date_tr date,cons_id int foreign key references consumer (cons_id), train_id int foreign key references trainer (train_id)); Create table trainer (train_ID int primary key,trainer_name varchar(20), Price int,plan_id int foreign key references training_plan (plan_id), Mid int foreign key references Mangers ( Mid)); Create table Mangers ( M ID int primary key, phone_number char(20), Manger_name varchar (20)); Create table employee_acceses(Em_id int primary key, password varchar(10),email varchar(15),train_id int foreign key references Trainer (train_id)); Create table Equipment(E_ID int primary key,_E_nsme varchar(20), E_type char (15),cons_id int foreign key references consumer (cons_id),sub_id int foreign key references subcripition (sub_id),plan_id int foreign key references trainig_plan (plan_id)); Create table Subscription (Sub_ID int primary key, Sub_date date, Sub_time int,cons_id int foreign key references consumer (cons_id): Create table Gust_access(G_ID int primary key,_G_email varchar(15),Password varchar(10),cons_id int foreign key references consumer (cons_id)); insert into consumer values(2200001298,0558840009,154,25,'Ahmed Mohammed Alan2i',60); insert into consumer values(2200001396,0558841459,160,30, 'Khiled Salim Alotibi", 70); insert into consumer values(2200025361,0502066543,170,23, 'Ali Nassser Alqahtani",65); insert into Payment values (11000,19012023,250, 'apple pay'); insert into Payment values (11001,20012023;,300, visa'): insert into Payment values(11002,'17-01-2023',500, 'cash'); insert into trainig_.paln values (33000,25012023,1;00); insert into trainig_pain values (33001,27012023,9;00); insert into trainig_paln values(33002,'29-01-2023,'10;00') insert into trainer values(1000129387,'Ahmed Ali khiled, 300); insert into trainer values(1000129902,' Yosuif Alt khiled',150); insert into trainer values (1000127645, 'Aiman Salim Alili, 250); insert into Mangers values(2130486365,0557463524, 'Omar Ahmed Alnasser'): insert into Mangers values(21304838632,055749264,'Marrooq fahad Alotib'): insert into Mangers values(21302937627,0557460192, 'Faisal sami Alqadir'): insert into employee_acceses values(10001,'sm*nd)", em10001@gmail.com?) insert into employee_acceses values(10002,'ekjdic:, 'em10002@gmailcom'); insert into employee_acceses values(10003,'efjiji', 'em10003@gmail.com'); insert into Equipment values(90000, 'upper body machin', 'h'); insert into Equipment values(90001, 'Lower body machin", 'M'); insert into Equipment values(90002, 'full body machin', 'L'): insert into Subscription values (000,19012023;+10;00); insert into Subscription values (001,20012023;,00;00); insert into Subscription values(002,'15-01-2023;,09;00'); insert into Gust_access values(100099,'gs100099@gmail.com', "gse001'); insert into Gust_access values(100082, gs 100082 gmailcom', 'gs0"2'); insert into Gust_access