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 vote211 views1 answer
Sql remove last x char
SQL
0 vote220 views1 answer
Assign value to var in SQL
SQL
0 vote228 views1 answer
User defined variables in sql
SQL
4 votes227 views2 answers
Oracle default date format
SQL
0 vote213 views1 answer
How to see the query of a view in mysql
SQL
0 vote236 views1 answer
Set a value by excuting stored procedure
SQL
2 votes228 views1 answer
Q operator in sql
SQL
0 vote253 views1 answer
SQL check if record exist
SQL
0 vote216 views1 answer
Left join in codeigniter query builder
SQL
3 votes231 views1 answer
Pl sql escape &
SQL