2 T A Aa A ADA c Emphasis Exercise... THeading 1 T Heading 2 1 Heading 3 Replace Select Editing Paragraph Styles calculate the total as ItemPrice* quantity, no need to consider the discount Amount Task2 SQL Join 1. List all orders for customer whose name begin with M. Order the result by the lastname hintl. Join Customer with Orders, what is the FK between those tables? 2. List productid, Product Name CategoryName and listprice for all products. Hint think about what tables you need to join and what is the relation between those two tables 3. List all customers information along with their address (you can use linel, city state and zipcode from the address table) 4. Reuse the previous query to list only customers who live in New York state 5. List all orders for customers in New York. Hint. You need to join three tables, what are they? 6. Reuse the query from the previous question to List all orders for customers in New York who used Visa to pay for their orders 7. List product name, category name and list price. 8. List first name, last name, city and state, orderID), date and ship amount 9. List all orders along with discount amount and quantity Question Answer Task 1-1 I D. Focus