Changes between Version 8 and Version 9 of Ф4


Ignore:
Timestamp:
01/15/24 01:03:31 (8 months ago)
Author:
153135
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Ф4

    v8 v9  
    33
    44== Приказ на клиент кој извршил најмногу нарачки и потрошена сума  ==
    5 SELECT u.user_id, COUNT (p.payment_id) AS total_orders,SUM(p.amount) AS total_spent\\
    6 FROM User u
    7 JOIN Payment p ON u.user_id=p.user_id \\
    8 GROUP BY u.user_id \\
    9 ORDER BY total_orders DESC,total_spent DESC \\
    10 LIMIT 1
     5[[Image('1_.PNG')]]
    116== Извештај за вкупно продадени планови ==
    127