SQL
Finding Distinct Values and Counts Across Multiple Columns
Retrieve unique combinations of values from multiple columns and count their occurrences, providing insights into data distribution.
SELECT
product_category,
product_color,
COUNT(*) as combination_count
FROM
products
GROUP BY
product_category, product_color
ORDER BY
combination_count DESC, product_category, product_color;
How it works: This query helps in understanding the distribution of data across multiple attributes. It groups products by unique combinations of `product_category` and `product_color`, then counts how many products fall into each combination. This is highly useful for inventory analysis, identifying popular product variations, or understanding which categories and colors are most prevalent in a dataset. The `ORDER BY` clause arranges the results by the most frequent combinations first, then by category and color for consistent ordering.