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.​

Answer 1

Explanation:

(e) Give the output of following SQL statement based on table GRADUATE: (I) ... (b) To list names of all coaches with their date of appointment (DATOFAPP) in ...

Answer 2

Explanation:

B one is correct i thik ok