Possible Answers

1. mysql> select f_name, l_name from employee_data       
       -> where salary <= 90000 
       -> AND title NOT LIKE '%programmers%';
       
   +---------+------------+
   | f_name  | l_name     |
   +---------+------------+
   | Anamika | Pandit     |
   | Mary    | Anchor     |
   | Fred    | Kruger     |
   | John    | MacFarland |
   | Edward  | Sakamuro   |
   | Alok    | Nanda      |
   | Hassan  | Rajabi     |
   | Paul    | Simon      |
   | Arthur  | Hoopla     |
   | Danny   | Gibson     |
   | Monica  | Sehgal     |
   | Hal     | Simlai     |
   | Joseph  | Irvine     |
   | Shahida | Ali        |
   +---------+------------+
   14 rows in set (0.00 sec)
   
   

2. The command displays names (last name followed by first name) of employees who are not in the marketing division and are less than 30 years of age.

   mysql> SELECT l_name, f_name from employee_data
       -> where title NOT LIKE '%marketing%'
       -> AND age < 30;
   +----------+---------+
   | l_name   | f_name  |
   +----------+---------+
   | Sharma   | Manish  |
   | Pandit   | Anamika |
   | Anchor   | Mary    |
   | Sakamuro | Edward  |
   +----------+---------+
   4 rows in set (0.00 sec)
   
   

3. mysql> select emp_id, f_name, l_name from
       -> employee_data where age > 32 
       -> and age < 40;
       
   +--------+--------+------------+
   | emp_id | f_name | l_name     |
   +--------+--------+------------+
   |      7 | John   | MacFarland |
   |     10 | Hassan | Rajabi     |
   |     14 | Roger  | Lewis      |
   |     15 | Danny  | Gibson     |
   |     16 | Mike   | Harper     |
   |     21 | Peter  | Champion   |
   +--------+--------+------------+
   6 rows in set (0.00 sec)
   
   

4. mysql> select f_name, l_name from employee_data               
       -> where age = 32 AND 
       -> title NOT LIKE '%programmer%';
   
   +---------+--------+
   | f_name  | l_name |
   +---------+--------+
   | Kim     | Hunter |
   | Shahida | Ali    |
   +---------+--------+
   6 rows in set (0.01 sec)