Changes between Version 15 and Version 16 of AdvancedReports


Ignore:
Timestamp:
09/25/25 01:05:40 (3 weeks ago)
Author:
223270
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AdvancedReports

    v15 v16  
    5959       COUNT(r.id_reservation) AS reservation_count
    6060FROM travel_sage.reservation r
    61 GROUP BY month
    62 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_count
    71 FROM travel_sage.users u
    7261GROUP BY month
    7362ORDER BY month;