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

7 votes141 views4 answers
Index in mysql
SQL
1 vote154 views1 answer
Sql group by sum with condition
SQL
0 vote152 views1 answer
Psql no such file or directory
SQL
1 vote137 views1 answer
Set autoincrement to 0
SQL
1 vote131 views1 answer
Oracle first row
SQL
2 votes141 views5 answers
SQL trigger
SQL
0 vote148 views1 answer
Alter check command
SQL
0 vote146 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote146 views1 answer
Sql query tags
SQL
0 vote138 views1 answer
Mysql select all where count more than"
SQL