Question

Q4. Based on the table student below, write SQL statements for the following questions: (5)
) 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.
ii) Change Raj Verma's grade to 9
iv) Display the details of all students who have secured distinction marks(75 or more)
) Delete all the records of students who have secured less than 20.
STUDENT_NAME
ADM_NO
GRADE
MARKS
A001
88
Ravi Kumar
A002
77
Anu Dutt
23
A003
Raj Verma
7
91
A004
Amarjeet Singh
8
12
A005
Rajeev Puri​

Answer 1

Answer:

SQL Basic Select Statement: Exercise-30 with Solution

Write a SQL query to find the name and price of the cheapest item(s).

Sample table: item_mast

Answer 2

Explanation:

GG

dfji it to k when ulti raf oo