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

0 vote314 views2 answers
Postgres having
SQL
11 votes322 views1 answer
Oracle view source
SQL
0 vote321 views1 answer
Mssql + bit + in python orm
SQL
2 votes332 views1 answer
Postgresql create table as select
SQL
0 vote321 views4 answers
First max salary in sql
SQL
0 vote313 views1 answer
Isnull in sqlite
SQL
0 vote315 views1 answer
How to update sql server version
SQL
0 vote295 views1 answer
On update current_timestamp jpa
SQL
1 vote321 views1 answer
Oracle enable job
SQL
0 vote289 views1 answer
Change mysql version to 5.7 in ubuntu
SQL