Mr. Manav, a database administrator in “Global Educational and Train

Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” for the upcoming training schedule:Traini ng_IdNameEmail_IdTopicCityFeeND01Ms. Rajan[email protected]Cyber SecurityNew Delhi10000GU01Ms. Urvashi[email protected]ICT in EducationGurugram15000FD01Ms. Neenaneenarediff.comCyber SecurityFaridabad12000ND01Mr. VinayNULLICT in EducationNew Delhi13000GU02Mr. Naveen[email protected]Cyber SecurityGurugramNULLHelp 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 training.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);