Using Visual studio $2022$ c# please give step by step instructions with the code and every step including installling packages and everything from start to finish as detailed as possible.

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