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

1 vote89 views1 answer
Into sql
SQL
1 vote133 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote129 views1 answer
Sql find all different values in column
SQL
3 votes123 views4 answers
Stop MySQL
SQL
3 votes122 views1 answer
Show index table
SQL
20 votes125 views4 answers
Sqlite create table if not exists
SQL
19 votes122 views2 answers
Mysql add column after another
SQL
0 vote121 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote134 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote123 views1 answer
Renommer table sql
SQL