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

2 votes185 views2 answers
Sql first character
SQL
6 votes191 views4 answers
Mysql update set
SQL
0 vote185 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote220 views1 answer
Psql create usr
SQL
11 votes223 views3 answers
Change column name sql server management studio
SQL
4 votes184 views1 answer
Oracle error compilation line
SQL
0 vote203 views1 answer
Sql select lowest value row
SQL
0 vote185 views1 answer
How to fetch unique records from two tables
SQL
0 vote182 views2 answers
Get all index postgres
SQL
6 votes180 views4 answers
Sqlite drop table
SQL