1. Write an SQL query to list customer first name, last name, customer code for customers who purchased any kind of saw. (hint: p_descript like *saw*). You need to join the Customer, Product, Vendor, and Invoice tables for this query.

2. Write an SQL query to list customer first name, last name, and the total value of the products that have been purchased by the customer. But the result should be shown in two columns: one column is Name (which is the combination of first name and last name, separated by space or comma), the other column is TotalValue. Only show customers who have purchased more than $100.

CUSTOMER PRODUCT VENDOR INVOICE CUSTOMER PRODUCT VENDOR 1 INVOICE CUSTOMER PRODUCT VENDEOR VI INVOICE CUSTOMER PRODUCT VENDOR INVOICE