SQL query to count number of distinct products

Question

how many customers ordered a distinct products and sort by count of distinct products?

Answer 1

Hi Preethi,

Use below SQL query,

SELECT CUST_ID, COUNT(DISTINCT PROD_ID) FROM ORDERS GROUP BY CUST_ID ORDER BY COUNT(DISTINCT PROD_ID);