Saved Bookmarks
| 1. |
Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” for the upcoming training schedule:TrainingHelp him in writing SQL query for the following purpose:(i) To count how many female candidates will be attending the training.(ii) To display list of free trainings.(iii) To display all the cities where Cyber Security training is scheduled along with its fee.(iv) To add a column feedback with suitable data type |
|
Answer» (i) Select count(name) from training where name like ‘Ms.%’; (ii) Select * from training where fee is NULL; (iii) Select city, fee from training where topic = ‘Cyber Security’; (iv) Alter table training add feedback varchar(20); |
|