SUM

<> - НЕ равно

-- Calculate total sum of products in stock
SELECT SUM(unit_price * units_in_stock)
FROM products
WHERE discontinued <> 1;