Changes between Version 5 and Version 6 of Ф4
- Timestamp:
- 12/18/23 10:31:36 (9 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ф4
v5 v6 3 3 4 4 == Приказ на клиент кој извршил најмногу нарачки и потрошена сума == 5 SELECT u.user_id, COUNT (p.payment_id) AS total_ord Ers,SUM(p.amount) AS total_spent\\5 SELECT u.user_id, COUNT (p.payment_id) AS total_orders,SUM(p.amount) AS total_spent\\ 6 6 FROM User u 7 7 JOIN Payment p ON u.user_id=p.user_id \\