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

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