Changes between Version 15 and Version 16 of AdvancedReports
- Timestamp:
- 09/25/25 01:05:40 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AdvancedReports
v15 v16 59 59 COUNT(r.id_reservation) AS reservation_count 60 60 FROM travel_sage.reservation r 61 GROUP BY month62 ORDER BY month;63 }}}64 65 66 === Приказ на бројот на нови корисници по месец67 Прикажува број на новорегистрирани корисници по месец.68 {{{69 SELECT DATE_TRUNC('month', u.birth_date) AS month,70 COUNT(u.id_user) AS new_user_count71 FROM travel_sage.users u72 61 GROUP BY month 73 62 ORDER BY month;