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

5 votes141 views3 answers
Bash: mysql: command not found
SQL
0 vote154 views1 answer
How to to get time in sql
SQL
1 vote124 views1 answer
Delete triger pl pg sql
SQL
0 vote128 views1 answer
Postgre admin slow
SQL
1 vote145 views1 answer
Oracle user last connection date
SQL
1 vote132 views1 answer
How to drop function in sql
SQL
1 vote146 views1 answer
Create table variable in sql stored procedure
SQL
2 votes124 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote141 views2 answers
How to display enum value sql server
SQL
1 vote146 views1 answer
Lpad function in sql oracle
SQL