Changes between Version 3 and Version 4 of Ф4

Timestamp:

12/18/23 10:23:15 (9 months ago)

Author:

153135

Comment:

--

Ф4

@@ -3 +3 @@
 
 == Приказ на клиент кој извршил најмногу нарачки и потрошена сума  ==
-
+SELECT u.user_id, COUNT (p.payment_id) AS total_ordErs,SUM(p.amount) AS total_spent\\
+FROM User u
+JOIN Payment p ON u.user_id=p.user_id \\
+GROUP BY u.user_id \\
+ORDER BY total_orders DESC,total_spent DESC \\
+LIMIT 1
 == Извештај за вкупно продадени планови ==