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

27 votes220 views3 answers
Mysql delete row
SQL
0 vote100 views1 answer
How to connect postgresql database with java
SQL
0 vote105 views1 answer
Oracle webcenter content search enginer
SQL
0 vote104 views1 answer
Basic structure of sql expression having clause
SQL
12 votes116 views10 answers
Google
SQL
0 vote102 views1 answer
Nueva tabla mysql
SQL
0 vote109 views2 answers
Athena drop partition
SQL
7 votes171 views2 answers
Sql empty table
SQL
3 votes97 views2 answers
To_char oracle
SQL
0 vote91 views1 answer
Database db connection string format
SQL