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;