Online MySQL course - Finding the minimum and maximum values

MySQL provides inbuilt functions to find the minimum and maximum values.

SQL provides 5 aggregate functions. They are:

• MIN(): Minimum value
• MAX(): Maximum value
• SUM(): The sum of values
• AVG(): The average values
• COUNT(): Counts the number of entries

In this session of the online MySQL course, we'll look at finding the minimum and maximum values in a column.

MySQL MIN() - Minimum value

select MIN(salary) from employee_data;

+-------------+
| MIN(salary) |
+-------------+
|       70000 |
+-------------+
1 row in set (0.00 sec)

MySQL MAX() - Maximum value

select MAX(salary) from employee_data;

+-------------+
| MAX(salary) |
+-------------+
|      200000 |
+-------------+
1 row in set (0.00 sec)

1. List the minimum perks package.
2. List the maximum salary given to a "Programmer".
3. Display the age of the oldest "Marketing Executive".
4. (Tricky!) Find the first and last names of the oldest employee.