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 vote163 views2 answers
Sql select inside select
SQL
0 vote175 views1 answer
Postgresql copy backup table
SQL
0 vote177 views1 answer
Mysql check if lowercase
SQL
4 votes166 views4 answers
Rollback in sql
SQL
7 votes161 views3 answers
Postgresql dump and restore db
SQL
0 vote156 views1 answer
Oracle list index on table
SQL
1 vote229 views1 answer
How to put value in variable mysql
SQL
8 votes182 views1 answer
Oracle search text in all packages
SQL
0 vote164 views1 answer
Add multiple field in table sql
SQL
0 vote174 views1 answer
Get record which is available in one table but not in another mysql
SQL