Possible Answers

1. mysql> select MIN(perks) from employee_data;
   
   +------------+
   | MIN(perks) |
   +------------+
   |       9000 |
   +------------+
   1 row in set (0.00 sec)
   
   

2. mysql> select MAX(salary) from employee_data      
       -> where title = "Programmer";
   
   +-------------+
   | MAX(salary) |
   +-------------+
   |       80000 |
   +-------------+
   1 row in set (0.00 sec)
   
   

3. mysql> select MAX(age) from employee_data
       -> where title = 'Marketing Executive';
   
   +----------+
   | MAX(age) |
   +----------+
   |       30 |
   +----------+
   1 row in set (0.00 sec)
   
   

4. Here is one way to do this without using aggregate functions.

   mysql> select f_name, l_name, age 
       -> from employee_data
       -> order by age DESC limit 1;
   
   +--------+--------+------+
   | f_name | l_name | age  |
   +--------+--------+------+
   | Paul   | Simon  |   43 |
   +--------+--------+------+
   1 row in set (0.00 sec)