Version 6 (modified by 9 months ago) ( diff ) | ,
---|
Напредни извештаи од базата
Приказ на клиент кој извршил најмногу нарачки и потрошена сума
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
Извештај за вкупно продадени планови
SELECT p.program_id,p.program_name,
COUNT(*) AS total_sold
FROM Program p
GROUP BY p.program_id,p.program_name
ORDER BY total_sold DESC
Attachments (10)
- 1_.PNG (8.9 KB ) - added by 8 months ago.
- 2_.PNG (6.6 KB ) - added by 8 months ago.
- 3_.PNG (10.9 KB ) - added by 8 months ago.
- 4_.PNG (13.4 KB ) - added by 8 months ago.
- 4_.2.PNG (19.9 KB ) - added by 8 months ago.
- 4_.3.PNG (11.5 KB ) - added by 8 months ago.
- data1.jpg (43.8 KB ) - added by 7 months ago.
- payment.PNG (15.0 KB ) - added by 7 months ago.
- prihod.jpg (43.6 KB ) - added by 7 months ago.
- period.jpg (24.9 KB ) - added by 7 months ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.