Changes between Version 26 and Version 27 of AdvancedReports

Timestamp:

04/09/24 14:37:50 (9 months ago)

Author:

184006

Comment:

--

AdvancedReports

@@ -277 +277 @@
   avg_sales_quantity DESC;
 }}}
+== Прикажи го продуктот за кој постојат најмал број направени нарачки.
+{{{
+
+WITH product_orders_count AS (
+    SELECT
+        p.id AS product_id,
+        p.name AS product_name,
+        p.description AS product_description,
+        p.price AS product_price,
+        COALESCE(COUNT(o.id), 0) AS orders_count
+    FROM
+        project.products p
+    LEFT JOIN
+        project.product_are_made_orders pamo ON p.id = pamo.id_products
+    LEFT JOIN
+        project.orders o ON pamo.id_orders = o.id
+    GROUP BY
+        p.id, p.name, p.description, p.price
+)
+SELECT
+    product_id,
+    product_name,
+    product_description,
+    product_price,
+    orders_count
+FROM
+    product_orders_count
+WHERE
+    orders_count = (
+        SELECT MIN(orders_count)
+        FROM product_orders_count
+    );
+
+}}}