What is the full name of the customer who purchased the highest amount of total price in a single purchase?
full name of the customer = FirstName, MiddleInitial, LastName; highest amount of total price refers to MAX(MULTIPLY(Quantity, Price));
SELECT T2.FirstName, T2.MiddleInitial, T2.LastName FROM Sales AS T1 INNER JOIN Customers AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN Products AS T3 ON T1.ProductID = T3.ProductID GROUP BY T1.SalesID, T1.Quantity, T3.Price, FirstName, MiddleInitial, LastName ORDER BY T1.Quantity * T3.Price DESC LIMIT 1
database name:db_id sales
Customers table Customers Cols: Customer ID dtype integer, First Name dtype text, Middle Initial dtype text, Last Name dtype text, 
Employees table Employees Cols: Employee ID dtype integer, First Name dtype text, Middle Initial dtype text, Last Name dtype text, 
Products table Products Cols: Product ID dtype integer, Name dtype text, Price dtype real, 
Sales table Sales Cols: Sales ID dtype integer, SalesPerson ID dtype integer, Customer ID dtype integer, Product ID dtype integer, Quantity dtype integer, 
