Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who represents at least one customer with a credit limit of $500. List each sales rep only once in the results. Task 10: Repeat Task 9, but this time do not use a subquery.

Using software.subscriptions table, pull all columns for subscriptions that have been cancelled.

Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”.  Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your student table select all students where the last name starts with an “S” and is at least three characters in length.