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

0 vote140 views1 answer
Mysql a from on this page has
SQL
1 vote141 views2 answers
Regex starts with
SQL
1 vote147 views1 answer
Sql select whole row max column
SQL
1 vote165 views1 answer
Mysql previous year
SQL
0 vote129 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote139 views1 answer
Mysql query to check record exists in database table or not
SQL
10 votes150 views1 answer
Oracle dependencies table
SQL
0 vote144 views1 answer
Drop all triggers oracle
SQL
-2 votes233 views1 answer
How-to-remove-mysql-root-password
SQL
5 votes126 views1 answer
Mysql get last day of month
SQL