Write a SQL statement to determine the price (prod_price) of the most expensive item in the Products table which costs no more than 10, name the calculated field max_price.


SELECT MAX(prod_price) AS max_price
FROM Products
WHERE prod_price <= 10;

Comment on this FAQ