SQL Query
SELECT Customer.FirstName, Customer.LastName, Invoice.CustomerId, Invoice.BillingCountry, Invoice.InvoiceId, Invoice.BillingCity, SUM(Invoice.Total) AS Total FROM Customer INNER JOIN Invoice ON Customer.CustomerId = Invoice.CustomerId GROUP BY Invoice.InvoiceId 1. Write a query to select to compute total amount paid by each customer based on their BillingCountry…