Computer Science, asked by gayathrizz0210, 7 months ago

please help me write the queries and syntax in My SQL to 1. To increment marks by 10 . 2. To display name & marks of students, who are from section ‘A’. 3. To display the information all the students, whose name is ANAND 4. To display student id, Name, DOB of those students who are born between ‘2005- 01-01’ and ‘2005-12-31’. 5. To display student id, Name, DOB, Marks of those male students 6. To display student id, Gender, Name, DOB, Marks of students whose division is B and who scored marks more than 50,. 7.To list the students details having class as xi and division is either C or D. 8.To display the details of all students whose division is not equal to E. 9.To display name and gender of all students whose student id lies between 300 and 400

Answers

Answered by surajnegi0600

Answer:

Answer of the following given queries are properly explained given below.

Explanation:

1. To increment marks by 10:

UPDATE students SET marks = marks + 10;

2, To display name & marks of students who are from section ‘A’:

SELECT name, marks FROM students WHERE section = 'A';

3. To display the information all the students whose name is ANAND:

SELECT * FROM students WHERE name = 'ANAND';

4. To display student id, Name, DOB of those students who are born between ‘2005- 01-01’ and ‘2005-12-31’:

SELECT student_id, name, dob FROM students WHERE dob BETWEEN '2005-01-01' AND '2005-12-31';

5. To display student id, Name, DOB, Marks of those male students:

SELECT student_id, name, dob, marks FROM students WHERE gender = 'Male';

6. To display student id, Gender, Name, DOB, Marks of students whose division is B and who scored marks more than 50:

SELECT student_id, gender, name, dob, marks FROM students WHERE division = 'B' AND marks > 50;

7. To list the students details having class as xi and division is either C or D:

SELECT * FROM students WHERE class = 'xi' AND (division = 'C' OR division = 'D');

8. To display the details of all students whose division is not equal to E:

SELECT * FROM students WHERE division != 'E';

9. To display name and gender of all students whose student id lies between 300 and 400:

SELECT name, gender FROM students WHERE student_id BETWEEN 300 AND 400;