Using the computational language in SQL script it is possible to write a code scheduled game we will keep a unique 8 character code, the date, time and location.
Writting the code in  SQL script:
SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,
Customer.firstName+' '+ Customer.lastName as customer
FROM Customer, Trainer
WHERE Trainer.handlingCustomer = Customer.id;
SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,
Customer.firstName+' '+ Customer.lastName as customer
FROM Customer, Trainer
WHERE Trainer.handlingCustomer = Customer.id AND
Customer.firstName = 'Robert';
SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,
Customer.firstName+' '+ Customer.lastName as customer
FROM Customer, Trainer
WHERE Trainer.handlingCustomer = Customer.id AND
Trainer.firstName = 'Mary';
SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,
Customer.firstName+' '+ Customer.lastName as customer
FROM Customer, Trainer
WHERE Trainer.handlingCustomer = Customer.id AND
Trainer.hiredIn >= 2015;
See more about  SQL script at brainly.com/question/15693585
#SPJ1
