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 vote123 views1 answer
Postgresql show owner of database
SQL
0 vote146 views1 answer
Capabilities of sql select statements
SQL
0 vote112 views1 answer
Sql server phone constraint
SQL
0 vote115 views1 answer
Mysql exception output
SQL
24 votes102 views4 answers
How to add column sql
SQL
0 vote96 views1 answer
Calculate date and convert to yearsmysql
SQL
10 votes123 views1 answer
Oracle all_dependencies
SQL
4 votes109 views3 answers
Sqlite show columns
SQL
9 votes117 views6 answers
Check constraint in sql
SQL
1 vote125 views1 answer
Oracle grant select on schema
SQL