Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT product_name, price, IF(stock > 0, 'In Stock', 'Out of Stock') AS availability, COALESCE(discount_price, price) AS effective_price, CASE WHEN price < 20 THEN 'Budget' WHEN price < 100 THEN 'Mid-range' ELSE 'Premium' END AS price_tier FROM products;
Result
Open