2. Write a select statement that returns these columns from the customer_address view that you created in Exercise 1. Customer_id, last_name, first_name, bill_line 1

3. Create a view named order_item_products that returns the following columns from the orders, order_items, and products table: From the orders table: order_id, order_date, tax_amount, and ship_date From the order_items table: item_price, discount_amount, final_price (item_price minus discount_amount), quantity, and item_total (sum of quantity * (item_price - discount_amount)). From the products table: product_name