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 vote185 views1 answer
Psql client write to bash variable
SQL
5 votes195 views1 answer
JBDC
SQL
1 vote210 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote208 views1 answer
Postgres row expiration
SQL
3 votes207 views1 answer
Postgres count distinct
SQL
5 votes203 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
2 votes202 views2 answers
Sqlalchemy filter or
SQL
1 vote189 views1 answer
How to print longest name in sql
SQL
4 votes266 views2 answers
Delete all table oracle
SQL
0 vote198 views1 answer
Enable Rabbitmq management plugin
SQL