Use MySQL and the Sales Company database to write the following queries.

After getting your queries to work in mysql, paste your queries in the submission box for this assignment.

1. Find all customers with the last name Smith. Show all columns.

2. Find all customers with a balance greater than 500 and who are from the 615 area code. Show first name, last name, area code and balance.

3. Find all vendors from Tennessee or Kentucky. Show all columns.

4. Show all products that have a quantity on hand less than 40. Show description, quantity on hand and price.

5. Show all products that have a price greater than $100.

6. Show the invoices for all customers except for the one with customer code 10011.

7. Show all Lines

mysql> show databases; +- | Database || information_schema classicmodels || construction || employees || music mysql || northwind I performance_schema I player Il test 10 rows in set (0.00 sec)