Question

Stud id
Name
Class Sec Maths Science Social Total Marks
1001
Abhinav
X
A
80
78
90
1
1002
Akshaya
X
A
90
82
85
1003
Bharathi
X
B
70
60
75
1004
Catherine
X
B
78
82
95
1005
Dhanush
Х
С
90
88
90
1. Set "Stud id field as the primary key.
2. Enter the above mentioned records in the table.
3. Create a query to find the values of “TotalMarks" field by adding Maths, Science
and Social
4. Create a query to display the Sname for those who scored 80 and above in the
"Maths" subject
5. Sort the records in the descending order according to the SName field.
6. Delete the 5 record​

Answer 1

Answer:

Hi mate what 's your question.