Problem Statement

Problem Description A training academy keeps records of its trainees, its trainers, and every training session a trainee attends. Each trainer teaches one subject, and a single trainee may attend sessions conducted by several different trainers (and may attend more than one session with the same trainer). Write an SQL query to display the names of trainees who have attended at least one training session conducted by the trainer named Shon and have not attended any training session conducted by the trainer named Eliud . Display the results in ascending order of trainee_id . Schema Table: trainee Column Name Data Type Constraint Description trainee_id INTEGER PRIMARY KEY Unique id of the trainee trainee_name VARCHAR(255) Name of the trainee trainee_gender VARCHAR(50) Gender of the trainee Table: trainer Column Name Data Type Constraint Description trainer_id INTEGER PRIMARY KEY Unique id of the trainer trainer_name VARCHAR(255) Name of the trainer subject VARCHAR(255) Subject taught by t