In this lesson, you learned how to create reports and how to display them in a Web application. You will use the same chinook da
tabase that you've used in previous assignments. Create a report that displays back the total sales by country.
Create both a table and pie chart (as you have done in this lesson).
Since you aren't expected to write the SQL statement that aggregates this data, use the information below:
SELECT Customer.Country, SUM(Invoice.Total) AS 'Total' FROM Invoice INNER JOIN CUSTOMER ON Invoice.CustomerId = Customer.CustomerId GROUP BY Customer.Country