To display the records from table student in alphabetical order as per the name of the student.

Q. Write SQL queries for (i) to (iv), which are based on the table: STUDENT given in the question 4(g):

(i) To display the records from table student in alphabetical order as per the name of the student.

(ii) To display Class, Dob and City whose marks is between 450 and 551.

(iii) To display Name, Class and total number of students who have secured more than 450 marks, class wise.

(iv) To increase marks of all students by 20 whose class is "XII".

Answer =

(i)
SELECT * FROM Student ORDER BY Name;

(ii)
SELECT Class, DOB, City FROM Student
WHERE Marks BETWEEN 450 AND 551;

OR

SELECT Class, DOB, City FROM Student
WHERE Marks >= 450 AND Marks <= 551 ;

(iii)
SELECT Name, Class, COUNT(*) FROM Student
GROUP BY Class HAVING Marks > 450;

(iv)
UPDATE Student SET Marks = Marks + 20 WHERE Class = "XII";