Question

Write MYSQL Queries for the following :

STUDENT

ROLLNO NAME MARKS1 MARKS2

1 RAJ 54 66

2 RAM 44 77

3 ROSHNI 77 79

4 ROHAN 23 98

a. To display all the data from table.

b. To display only name and marks1 from table.

c. To insert one more row as (5,”resham”,55,76)

d. To delete the record of those students who are having marks1 less than 30.

e. To update the marks1 as 49 of those students who secured marks less than 30.

plzzzz answer​

Answer 1

Answer:

here is your answer..........................