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 vote141 views1 answer
Allow null in psql
SQL
0 vote148 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote169 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
1 vote348 views1 answer
How to make a select in sql
SQL
1 vote130 views1 answer
Postgres get timestamp
SQL
0 vote137 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
6 votes135 views1 answer
How to count number of rows in sql
SQL
0 vote149 views1 answer
How to check event scheduler status mysql
SQL
0 vote132 views2 answers
Postgresql get last day of month
SQL
1 vote135 views1 answer
Return size of tables in mysql
SQL