home / shop

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

This data as json, CSV

master_categorytypecategory_counttotal_products
Sidebar occasion 10 242
Color flower 6 176
NoSidebar occasion 10 175
NoColor flower 6 170
NoSeasonal occasion 5 109
Funerals occasion 5 98
Seasonal addon 4 92
NoWeddings occasion 3 89
NoFunerals occasion 5 71
Bouquets flower 2 63
Plants addon 6 61
Sidebar flower 2 56
Weddings occasion 3 56
Seasonal occasion 2 54
NoPlants addon 6 47
Roses flower 3 45
NoRoses flower 3 39
Cafe flower 1 26
Cafe addon 4 21
NoSidebar flower 1 17
Funerals flower 1 6
Powered by Datasette · Queries took 1.113ms