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

please answer my question please help me ​

Answer 1

Answer:

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

please answer my question please help me