Question

Observe the table named “Training” given above carefully and predict the output of the following queries:

(i) select city from training where topic = 'Cyber Security';

(ii) select count(Training_Id) from training where email_id like '%gmail% ';

(iii) select AVG (Fee) from training where Topic = 'Cyber Security';

(iv) select name from training where INSTR (Email_Id, '@’)=0;

Answer 1

(i) New Delhi

Faridabad

Gurugram

(ii) 2

(iii) 11000

(iv) Ms. Neena