SQL LEARNING SERIES PART-14

Complete SQL Topics for Data Analysis
-> https://t.me/sqlspecialist/523

Today, we will learn about Advanced Filtering:

Advanced filtering in SQL involves using CASE statements for conditional logic within queries.

#### CASE Statement:
Allows conditional logic in a query, similar to a switch statement in other programming languages.

SELECT column1, column2,
    CASE
        WHEN condition1 THEN 'Result1'
        WHEN condition2 THEN 'Result2'
        ELSE 'DefaultResult'
    END AS custom_column
FROM table_name;

#### Example:

SELECT product_name, price,
    CASE
        WHEN price > 1000 THEN 'Expensive'
        WHEN price BETWEEN 500 AND 1000 THEN 'Moderate'
        ELSE 'Affordable'
    END AS price_category
FROM products;

This query categorizes products based on their price into 'Expensive', 'Moderate', or 'Affordable'.

Advanced filtering is useful for creating custom columns based on specific conditions in your data.

Share with credits: https://t.me/sqlspecialist

Hope it helps :)