1. Write a SQL statement to display invoices from vendors in CA state. List the invoice_id, vendor_id, vendor_name, vednor_state.

2. Write a SQL statement to count the number of vendors in CA state.

3. Write a SQL statement to find the largest invoice_total, the smallest invoice_total and the average invoice_total;

4. Write a SQL statement to count the number of invoices with invoice_total greater then average (invoice_total);

Using Murach's MySQL 5th edition.