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

8 votes158 views1 answer
Oracle current date plus 1 month
SQL
1 vote175 views1 answer
Moodle query item quiz
SQL
15 votes178 views1 answer
Mysql int range
SQL
0 vote173 views2 answers
How to get json data mysql
SQL
1 vote176 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote183 views1 answer
Convert sql server guid to varbinary
SQL
0 vote137 views1 answer
Procedures and functions in pl/sql
SQL
0 vote184 views1 answer
Create or replace view postgress
SQL
1 vote190 views2 answers
Insert sqlite
SQL
4 votes181 views1 answer
Restart for pg_hba.conf file
SQL