Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

02/03/24 20:30:26 (8 months ago)

Author:

201171

Comment:

--

AdvancedReports

@@ -43 +43 @@
     )
 }}}
+
+=== Извештај за сите продукти кои се нарачани во последните 6 месеци и нивната просечна оценка, подредени според категорија, име на продут и просечна оценка
+
+{{{
+select
+    category.category_name as category,
+    product.product_name as product_name,
+    avg(review.review_rating) as average_rating
+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
+join order_table on order_table_contains_product.order_id = order_table.order_id
+join review on product.product_id = review.product_id
+where
+    order_table.order_date between now() - interval '6 months' and now()
+group by
+    category.category_name,
+    product.product_name
+order by
+    category, product_name, average_rating;
+}}}