SELECT
Show all students names
SELECT Name FROM Student:
Show students who are 15 years old
SELECT * FROM Students WHERE Age = 15;
Show students named “Alice.”
SELECT * FROM Students WHERE Name = 'Alice';
Show all students ordered by name (A–Z).
SELECT * FROM Students ORDER BY Name ASC;
Show all students except Ben.
SELECT * FROM Students WHERE Name <> 'Ben';
Show all student grades
SELECT Grade FROM Students;
Show students who are in Grade 10
SELECT * FROM Students WHERE Grade = 10;
Show students named “Ben.”
SELECT * FROM Students WHERE Name = 'Ben';
Show all students ordered by age (youngest first).
SELECT * FROM Students ORDER BY Age ASC;
Show all students except Alice.
SELECT * FROM Students WHERE Name <> 'Alice';
Show student names and grades.
SELECT Name, Grade FROM Students;
Show students who are in Grade 11
SELECT * FROM Students WHERE Grade = 11;
Show students older than 15.
SELECT * FROM Students WHERE Age > 15;
Show all students ordered by grade (lowest first).
SELECT * FROM Students ORDER BY Grade ASC;
Show students in Grades 11 or 12.
SELECT * FROM Students WHERE Grade = 11 OR Grade = 12;
Show student names and ages
SELECT Name, Age FROM Students;
Show students who are 16 years old
SELECT * FROM Students WHERE Age = 16;
Show students younger than 17.
SELECT * FROM Students WHERE Age < 17;
Show all students ordered by grade (highest first).
SELECT * FROM Students ORDER BY Grade DESC;
Show students aged 16 or 17.
SELECT * FROM Students WHERE Age = 16 OR Age = 17;
Show all columns in the table
SELECT * FROM Students;
Show students who are 17 years old and in Grade 12.
SELECT * FROM Students WHERE Age = 17 AND Grade = 12;
Show students aged 15 and in Grade 10.
SELECT * FROM Students WHERE Age = 15 AND Grade = 10;
Show all students ordered first by grade (highest first), then by name (A–Z).
SELECT * FROM Students ORDER BY Grade DESC, Name ASC;
Show students whose names start with “A.”
SELECT * FROM Students WHERE Name LIKE 'A%';