Differences

This shows you the differences between two versions of the page.

--- sql:select [2022/07/08 09:04] – 185.92.25.28
+++ sql:select [2022/07/08 09:12] (current) – 185.92.25.28
@@ Line 40: / Line 40: @@
 <code sql>
 SELECT fname, lname FROM Students
-INNER JOIN Section
+INNER JOIN Teachers
-ON Students.no = Section.no
+ON Students.teacher = Teacher.no
 </code>
 ----
+===== Fetch maximum age from a table =====
+<code sql>
+SELECT MAX(age)
+FROM Students;
+</code>
+----
+===== Fetch minimum age from a table =====
+<code sql>
+SELECT MIN(age)
+FROM Students;
+</code>
+----
+===== Fetch sum of ages from a table =====
+<code sql>
+SELECT SUM(age)
+FROM Students;
+</code>
+----
+===== Fetch average age from a table =====
+<code sql>
+SELECT AVG(age)
+FROM Students;
+</code>
+----
+===== Fetch average age for each gender =====
+<code sql>
+SELECT AVG(age)
+FROM Students
+GROUP BY gender;
+</code>
+----