Myntra SQL Query Analysis | Filtering and Sorting in SQL and Snowflake

Flipkart SQL Query Analysis | Filtering and Sorting in SQL and Snowflake
SELECT * FROM FLIPKART--5L
WHERE CATEGORY = 'PHONE' --9K
AND PRICE BETWEEN 20000 AND 30000
AND BRAND IN ('SAMSUNG','REALME','POCO')
AND RAM IN ('5GB','4GB','6GB')--132
--AND DISCOUNT BETWEEN 10 AND 100
AND DISCOUNT = 10
ORDER BY PRICE DESC ;