-- Database schema
| Customers : CustomerID [ INTEGER ] primary_key , FirstName [ TEXT ] , MiddleInitial [ TEXT ] , LastName [ TEXT ] | Employees : EmployeeID [ INTEGER ] primary_key , FirstName [ TEXT ] , MiddleInitial [ TEXT ] , LastName [ TEXT ] | Products : ProductID [ INTEGER ] primary_key , Name [ TEXT ] , Price [ REAL ] | Sales : SalesID [ INTEGER ] primary_key , SalesPersonID [ INTEGER ] Sales.SalesPersonID = Employees.EmployeeID , CustomerID [ INTEGER ] Sales.CustomerID = Customers.CustomerID , ProductID [ INTEGER ] Sales.ProductID = Products.ProductID , Quantity [ INTEGER ] |
-- -- Give the product ID and name of the product with the highest prices among the quantity ranges from 400 to 500.

SELECT T1.ProductID, T1.Name FROM Products AS T1 INNER JOIN Sales AS T2 ON T1.ProductID = T2.ProductID WHERE T2.quantity BETWEEN 400 AND 500 ORDER BY T1.Price DESC LIMIT 1;