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 votes153 views2 answers
Truncate table
SQL
0 vote131 views2 answers
Mysql slave status
SQL
1 vote145 views3 answers
Mysql disable foreign keys check
SQL
0 vote140 views1 answer
Difference between min and max date sql
SQL
2 votes151 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote196 views1 answer
Sql commands in android
SQL
0 vote141 views1 answer
How to check even or odd in sql
SQL
0 vote140 views1 answer
Postgresql delete multiple rows
SQL
4 votes135 views3 answers
Oracle sql first day of quarter
SQL
0 vote212 views1 answer
Get statis values sql
SQL