I am using MySQL. The first image is what I need help on. The other three are to show you the columns and tables. Thank you so much.

Q.6) (20 points) Write a SELECT statement that answers this question: What is the total amount ordered for each product? Return these columns as shown in the screenshot: The product name from the Products table The total amount for each product in the Order ltems (Hint: You can calculate the total amount by subtracting the discount amount from the item price and then multiplying it by the quantity) Include a row that gives the grand total over all products Result Grid t Filter Rows a Search product name product total Fender Precision 559.99 978.60 Fender Stratocaster Gibson Les Paul 2517.90 Gibson SG 1208.16 Ludwig 5-piece Drum Set with Cymbals 489.99 253.15 Rodriguez Caballero 11 Tama 5-Piece Drum Set with Cymbals 679.99 Washburn D10S 598.00 303.79 Yamaha FG700S 7589.57 NULL