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

18 votes234 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote273 views1 answer
Sql server port 1434
SQL
0 vote268 views1 answer
Drop domain postgresql
SQL
11 votes334 views2 answers
Import mysql dump command line windows
SQL
0 vote282 views1 answer
Oracle array
SQL
2 votes278 views1 answer
How to find constraints on a table in oracle
SQL
3 votes267 views1 answer
Sql set null
SQL
0 vote263 views1 answer
Find wordpress version in database
SQL
0 vote225 views1 answer
Mysql offset from bottom
SQL
14 votes280 views1 answer
Oracle new column
SQL