In MySQL, Useing ClassicModels database below, how do I script it to display ProductLine total_sales by region like this;

a. Region-1 i. Productline-1 ---- Total Sales ii. Productline-2 ---- Total Sales iii. Productline-3 ---- Total Sales b. Region-2 i. Productline-1 ---- Total Sales ii. Productline-2 ---- Total Sales iii. Productline-3 ---- Total Sales c. Region-3

i. Productline-1 ---- Total Sales ii. Productline-2 ---- Total Sales iii. Productline-3 ---- Total Sales

CoursHeroTranscribedText

44 productlines * productLine textDescription htmlDescription image employees *employeeNumber lastName firstName extension email officeCode reports To job Title offices * officeCode city phone addressLine1 addressLine2 state country postalCode territory MySQL Sample Database Diagram +H products productCode productName productLine productScale productVendor product Description quantityInStock buyPrice MSRP customers customerNumber customerName contactLastName contactFirstName city state phone addressLine1 addressLine2 postalCode country salesRepEmployeeNumber creditLimit +H |++ +H et ef orderdetails * orderNumber * productCode quantityOrdered priceEach orderLineNumber orders orderNumber orderDate required Date shippedDate status comments customerNumber payments * customerNumber * checkNumber paymentDate amount