Question

Write SQL commands for the followings on the basis of given table

COACHING​

Answer 1

(i) To display names of those whose ages are more than 23.

• Select Name from Coaching where Age > 23;

(ii) To display the details of those staying in Delhi.

• Select * from Coaching where City = 'Delhi';

(iii) To display the details of those who live in Indore and are 36 y/o.

• Select * from Coaching where City = 'Indore' and Age = 36;

(iv) To delete records where the fee is more than 50000.

• Delete from Coaching where Fee > 50000;

(v) To display the details of those whose fee is 54000.

• Select * from Coaching where Fee = 54000;

• Select is used to display/retrieve data from a table.
• Delete is a DML command used to delete records from a table.
• Where is a clause that helps define a condition when using commands.