Mysql workbench procedure

DELIMITER //

CREATE PROCEDURE count_trainers_with_skill(IN description varchar(50))
BEGIN
SELECT Skill.Description ,count(Trainer.TrainerID) as NumOfTrainers
FROM Trainer, Skill, CertifiedTrainer
WHERE (Trainer.TrainerID=CertifiedTrainer.TrainerID) and CertifiedTrainer.SkillID =  Skill.SkillID and Skill.Description =description group by Skill.Description ;
END 
//
DELIMITER ;

/*Call for procedure with parameter*/
CALL count_trainers_with_skill("Shampooing");

Similar codes

3 votes114 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote116 views1 answer
Cast float mysql
SQL
0 vote107 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote108 views1 answer
Oracle apex run 404
SQL
2 votes120 views1 answer
How to show the whole table in sql
SQL
0 vote117 views3 answers
Duplicate row mysql
SQL
1 vote120 views1 answer
Postgresql datetrunc too slow
SQL
0 vote125 views1 answer
Sql select first and last record of each group
SQL
0 vote103 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
1 vote132 views1 answer
Ora-01109 database not open in oracle 19c
SQL