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 vote253 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote176 views1 answer
Sql beginning of previous month
SQL
0 vote194 views1 answer
Get the previous column of a table in mysql
SQL
8 votes185 views2 answers
Mysql query dates between two dates
SQL
0 vote190 views1 answer
Select last N rows mysql
SQL
50 votes290 views6 answers
Install mysql on ubuntu
SQL
2 votes186 views1 answer
Oracle number to percentage
SQL
16 votes213 views2 answers
Sql exists
SQL
1 vote201 views1 answer
Where not in array sql
SQL
0 vote182 views1 answer
Postgres call view
SQL