Use the sample database (four tables invoice, Product, LineItem, and Customer) to answer the following questions.

1. Give a SQL query that lists all customers in California and Nevada.

2. Give a SQL query that lists all products that have been purchased by a customer in California.

3. Give a SQL query that lists all line items that are part of invoice number 11731.

4. Give a SQL update statement that raises all prices by ten percent.

This can be done in a word document or just posted on here in order. Thank you!