Q4. Based on the table student below, write SQL statements for the following questions: [5]
1) Display the details of all
students of grade 8.
ii) Insert a new record for a student named Vinita Shukla in grade 7 adm_no A006 with marks
88.
III) Change Baj Verma's grade to 9
iv) Display the details of all students who have secured distinction marks(75 or more)
v) Delete all the records of students who have secured less than 20.
GRADE
MARKS
ADM_NO
STUDENT_NAME
9
88
A001
Ravi Kumar
8
77
A002
Anu Dutt
23
A003
Raj Verma
91
A004
Amarjeet Singh
8
12
A005
Rajeev Puri
Answers
Answered by
0
Answer:
not so Hard to find out the group bcoz we have to go to school tomorrow morning at the same number of the universal and Kecha will be the first time to explore new ways of learning and smart ways of learning and smart ways of learning and smart ways of learning and smart ways of learning and
Similar questions