Consider the following table:
Student
Write commands in SQL for (i) to (iv):
(i) To display the details of all those students who have IP as their optional subject.
(ii) To display name, stream and optional of all those students whose name starts with 'A'.
(iii) To give an increase of 3 in the average of all those students of humanities section who have Maths as their optional subject.
(iv) To display a name list of all those students who have average more than 75.