Changes between Version 6 and Version 7 of Ф4

Timestamp:

12/19/23 10:26:48 (9 months ago)

Author:

153135

Comment:

--

Ф4

@@ -17 +17 @@
 ORDER BY total_sold DESC\\
 
+== Извештај за вкупно купени планови од корисници и име на тие планови за последните 3 месеци ==
+SELECT p.program_name, COUNT (*) AS total_plans_paid \\
+FROM Program p \\
+JOIN Payment pm ON p.program_id=pm.program_id \\
+WHERE pm.payment_date >= DATE_SUB(CURRENT_DATE,INTERVAL 3 MONTH) \\
+GROUP BY p.program_name \\
+ORDER BY total_plans_paid DESC \\
 
 
 
+
+
+