-
mysql> select l_name, f_name, title
-> from employee_data where
-> title IN
-> ('Senior Programmer',
-> 'Multimedia Programmer');
+--------+--------+-----------------------+
| l_name | f_name | title |
+--------+--------+-----------------------+
| Hagan | John | Senior Programmer |
| Pillai | Ganesh | Senior Programmer |
| Rajabi | Hassan | Multimedia Programmer |
| Simon | Paul | Multimedia Programmer |
| Hoopla | Arthur | Multimedia Programmer |
+--------+--------+-----------------------+
5 rows in set (0.00 sec)
-
mysql> select f_name, l_name, salary from
-> employee_data where salary BETWEEN
-> 70000 AND 90000;
+---------+------------+--------+
| f_name | l_name | salary |
+---------+------------+--------+
| Anamika | Pandit | 90000 |
| Mary | Anchor | 85000 |
| Fred | Kruger | 75000 |
| John | MacFarland | 80000 |
| Edward | Sakamuro | 75000 |
| Alok | Nanda | 70000 |
| Hassan | Rajabi | 90000 |
| Paul | Simon | 85000 |
| Arthur | Hoopla | 75000 |
| Danny | Gibson | 90000 |
| Monica | Sehgal | 90000 |
| Hal | Simlai | 70000 |
| Joseph | Irvine | 72000 |
| Shahida | Ali | 70000 |
+---------+------------+--------+
14 rows in set (0.00 sec)
- The names and titles of all non programmers are displayed.
mysql> SELECT f_name, l_name, title from
-> employee_data where title NOT IN
-> ('Programmer', 'Senior Programmer',
-> 'Multimedia Programmer');
+---------+----------+----------------------------+
| f_name | l_name | title |
+---------+----------+----------------------------+
| Manish | Sharma | CEO |
| Anamika | Pandit | Web Designer |
| Mary | Anchor | Web Designer |
| Kim | Hunter | Senior Web Designer |
| Roger | Lewis | System Administrator |
| Danny | Gibson | System Administrator |
| Mike | Harper | Senior Marketing Executive |
| Monica | Sehgal | Marketing Executive |
| Hal | Simlai | Marketing Executive |
| Joseph | Irvine | Marketing Executive |
| Shahida | Ali | Customer Service Manager |
| Peter | Champion | Finance Manager |
+---------+----------+----------------------------+
12 rows in set (0.00 sec)
- The statement displays all non programmers who are not between the ages of 28 and 32.
mysql> SELECT f_name, l_name, title, age from
-> employee_data where title NOT IN
-> ('Programmer', 'Senior Programmer',
-> 'Multimedia Programmer') AND
-> age NOT BETWEEN 28 AND 32;
+---------+----------+----------------------------+------+
| f_name | l_name | title | age |
+---------+----------+----------------------------+------+
| Anamika | Pandit | Web Designer | 27 |
| Mary | Anchor | Web Designer | 26 |
| Roger | Lewis | System Administrator | 35 |
| Danny | Gibson | System Administrator | 34 |
| Mike | Harper | Senior Marketing Executive | 36 |
| Hal | Simlai | Marketing Executive | 27 |
| Joseph | Irvine | Marketing Executive | 27 |
| Peter | Champion | Finance Manager | 36 |
+---------+----------+----------------------------+------+
8 rows in set (0.00 sec)