Changes between Version 2 and Version 3 of AdvancedReports

Timestamp:

02/03/24 19:31:10 (8 months ago)

Author:

201171

Comment:

--

AdvancedReports

@@ -13 +13 @@
 group by product.product_name
 }}}
+
+=== Извештај за сите категории, нивните најмногу нарачани продукти и бројот на нарачки за продуктот
+{{{
+select
+    category.category_name as Category,
+    product.product_name as Product_Name,
+    count(order_table_contains_product.product_id) as Number_of_orders
+from
+    category
+join product_is_in_category on category.category_id = product_is_in_category.category_id
+join product on product_is_in_category.product_id = product.product_id
+join order_table_contains_product on product.product_id = order_table_contains_product.product_id
+group by
+    category.category_id,
+    category.category_name,
+    product.product_name
+having
+    count(order_table_contains_product.product_id) = (
+        select
+            count(*)
+        from
+            order_table_contains_product
+        join product on order_table_contains_product.product_id = product.product_id
+        join product_is_in_category on product.product_id = product_is_in_category.product_id
+        where
+            product_is_in_category.category_id = category.category_id
+       group by
+            order_table_contains_product.product_id
+    )
+}}}