Question

Name
Class
Marks
Roll_No
101
Х
765
107
Ajay
Suraj
Simran
IX
865
109
X
766
103
Aman
IX
821
104
Naresh
IX
1
a. Write SQL commands to create the above-given table. Set appropriate datatypes
for the fields.
b. Write a query to display the details of all the students studying in class X.
c. Write the query to change the Roll_No of the student named Aman to 106.
d. Write a query to delete the record where the value of mark is​

Answer 1

rewrite the question please didn't get it