# These are the results that you need to achieve:

# Show the last names and member IDs after eliminating every other person with
# salesID = 2 from the list.
+-----------+----------+
| LastName  | MemberID |
+-----------+----------+
| Lambert   |        7 |
| Kale      |        8 |
| Fernandez |        9 |
| Chrisman  |       13 |
| Wanner    |       14 |
| Taft      |       18 |
| Irving    |       19 |
| Crum      |       22 |
| Payne     |       29 |
| Goe       |       30 |
| MacArthur |       31 |
| Finney    |       32 |
| Ranier    |       33 |
+-----------+----------+
13 rows in set (X.XX sec)

# Show only alternative titles. Consider using the reserved word WHERE to specify the condition.
+--------------------+
| Title              |
+--------------------+
| Meet the Neurotics |
| Time Flies         |
| Neurotic Sequel    |
+--------------------+
3 rows in set (X.XX sec)

# Eliminate all jazz titles
+--------------------+
| Title              |
+--------------------+
| Meet the Neurotics |
| Smell the Glove    |
| Time Flies         |
| Neurotic Sequel    |
| Sonatas            |
+--------------------+
5 rows in set (X.XX sec)

# Only return the genres using the keyword DISTINCT.
+-------------+
| Genre       |
+-------------+
| alternative |
| metal       |
| classical   |
| jazz        |
+-------------+
4 rows in set (X.XX sec)

# Excercise 10 requires you to use boolean values with the keyword LIKE.
+--------+
| Region |
+--------+
| VA     |
| IN     |
| TX     |
| TX     |
+--------+
4 rows in set (X.XX sec)