Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

02/03/24 21:22:56 (8 months ago)

Author:

201171

Comment:

--

AdvancedReports

@@ -67 +67 @@
     category, product_name,number_of_reviews, average_rating;
 }}}
+
+=== Извештај за 10те најактивни корисници со најголем број нарачки
+
+{{{
+select
+    customer.user_id  as customer_id,
+    user_table.name_user  as customer_name,
+    count(order_table.order_id) as number_of_orders
+from
+    customer
+join order_table on customer.user_id = order_table.customer_id
+join user_table on customer.user_id = user_table.user_id
+group by
+    customer.user_id,
+    user_table.name_user
+order by
+    number_of_orders desc
+limit 10;
+}}}