Hi All - I have the following table:
My query to outputs a unique SKU based on the lowest price:
SELECT SKU, MIN(PRICE) FROM TABLE1
GROUP BY SKU
However, I need to perform a calculation on that aggregrate function. If a price is more than $10, it will deduct $10 off it. SQL does not allow calculation on the MIN(PRICE) function. How can I achieve this?