Consider the relational schema below: Customer(CustomerID,…
Consider the relational schema below: Customer(CustomerID, CustomerName, Country) Product(ProductID, ProductName, Price) Purchase(CustomerID, ProductID, PurchaseDate) Salesperson(SalespersonID, SalespersonName, ProductID) To retrive the CustomerName and the total amount spent by customers who have made at least one purchase, which of the following SQL queries is correct?