CODE EXAMPLE FOR SQL

mysql workbench view

CREATE OR REPLACE VIEW newtrainers AS
SELECT Trainer.Name, Trainer.Surname
FROM Trainer, Skill, CertifiedTrainer
WHERE (Trainer.TrainerID = CertifiedTrainer.TrainerID)