SELECT * FROM Students;
----
===== Fetch maximum 10 rows from a table =====
SELECT fname, lname FROM Students
LIMIT 10;
----
===== Fetch specific columns from a table =====
SELECT fname, lname FROM Students;
----
===== Filter data from a table =====
SELECT fname, lname FROM Students
WHERE rollno > 1234;
----
===== Fetch from two tables =====
SELECT fname, lname FROM Students
INNER JOIN Teachers
ON Students.teacher = Teacher.no
----
===== Fetch maximum age from a table =====
SELECT MAX(age)
FROM Students;
----
===== Fetch minimum age from a table =====
SELECT MIN(age)
FROM Students;
----
===== Fetch sum of ages from a table =====
SELECT SUM(age)
FROM Students;
----
===== Fetch average age from a table =====
SELECT AVG(age)
FROM Students;
----
===== Fetch average age for each gender =====
SELECT AVG(age)
FROM Students
GROUP BY gender;
----