Question

Average
Consider the following toble : Student
Adna Name. Stream
Optimal
Asha
Science
cs
1002 Aditya
Commerce P.Ed
1003
Sonali Humanities Maths
1004 Aman
Science
1005 Rishabh
Commerce
CS
60
65
Maite
85
i)to display the details of all those students who have "math" as their optional subject.
ii)to display name,stream,optional of the those students whose name starts with "A".
iii)to give an increase of 3 in the average of all those students of "science" steam who have "math" as these optional subject.
iv) to display a name list of all those students who have average more than 75.​

Answer 1

Answer: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.Read more on Sarthaks.com - https://www.sarthaks.com/296887/to-display-the-details-of-all-those-students-who-have-ip-as-their-optional-subject