Question

In this lesson, you learned how to create reports and how to display them in a Web application. You will use the same chinook database 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

Answer 1

create a report that displays back tge total sales by country