Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

01/10/24 10:27:23 (12 months ago)

Author:

184006

Comment:

--

AdvancedReports

@@ -56 +56 @@
 limit 1;
 }}}
+== Прикажување на продукти кои што би можело да се потрошат најбрзо бидејќи има побарано најголема количина за нив.
+{{{
+SELECT
+  p.name AS product_name,
+  p.description AS product_description,
+  AVG(o.quantity) AS avg_sales_quantity
+FROM
+  project.products p
+JOIN
+  project.product_are_made_orders po ON p.ID = po.id_products
+JOIN
+  project.orders o ON po.id_orders = o.ID
+GROUP BY
+  p.ID
+ORDER BY
+  avg_sales_quantity DESC;
+}}}