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