CREATE TABLE students ( id INT, name TEXT, marks INT ); INSERT INTO students VALUES (1,'Rahul',78), (2,'Anita',92), (3,'Suresh',67), (4,'Meena',88); SELECT * FROM students; SELECT name,marks FROM students WHERE marks > 80; SELECT COUNT(*) FROM students WHERE marks > 80; SELECT MAX(marks) FROM students; SELECT MIN(marks) FROM students; SELECT SUM(marks) FROM students; SELECT name,marks FROM students WHERE marks < 80; SELECT name,marks FROM students WHERE marks >=70 AND marks <=90; SELECT name,marks FROM students WHERE marks >=88; SELECT name, marks FROM students WHERE marks NOT BETWEEN 70 AND 90; SELECT name, marks FROM students ORDER BY marks DESC; SELECT name,marks FROM students ORDER BY marks ASC; SELECT name,marks
FROM students ORDER BY marks DESC LIMIT 1;

ORDER BY marks DESC LIMIT 1;