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 vote375 views1 answer
Sql field equals multiple values
SQL
8 votes79 views2 answers
Alter column name in mssql
SQL
0 vote124 views1 answer
Ajax error exception handeling
SQL
0 vote130 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote120 views1 answer
Search starting with mysql
SQL
0 vote122 views1 answer
Sql server beginning of month
SQL
0 vote125 views1 answer
Oracle locked objects
SQL
5 votes114 views1 answer
Update sql user password
SQL
0 vote129 views1 answer
Postgresql auto increment not working
SQL
0 vote110 views2 answers
Android sqlite tutorial for beginners
SQL