In visual studio $2022$ C# explain how to do this very detailed like I never coded before with all the code and step by step instructions for everything 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 a 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