Master Category Summary

Custom SQL query returning 21 rows (hide)

SELECT
  master_category,
  type,
  COUNT(*) as category_count,
  SUM(product_count) as total_products
FROM categories
WHERE master_category IS NOT NULL AND master_category != ''
GROUP BY master_category, type
ORDER BY total_products DESC

Edit SQL