Question

4. Write SQL commands for the followings on the basis of given table Student. 10X2-20
M
Stipend
Grade
Avg Mark
785
1
D
A
300110
68.6
350.00
73.1
50000
Stream
Medical
Commer
Commetve
Humanities
Nonmedical
Medial
Humanities
Nonmediul
Nonmedical
Commerce
Sabina
John
Robert
906
B
7
25000
C
Rubina
A
50000
920
A
Manan
Select all non medical students from student
b. list the name of those students who are in medical sorted by their name.
List all students sorted by AvgMark in descending order.
d. Uist all students who are in commerce and grade " 8".
e. Display the details of students who are either in Medical or Human bes
department.
1. Display the details of students who are either in Medical or Humanities
department and grade "A"
& Display the details of the student whose names start with "D" or end with
h. Display the details of students who are in Medical and name stat with "K"
Display the details of the student whose AvgMark is more than 70 and less
than 90
List the name of those students whose AvgMark is between 20 and 90
sorted by their name​

Answer 1

Answer:

Explanation:

jshdywbdujshbwusbsuebudushwusjs8whsuuw