Changes between Version 46 and Version 47 of AdvancedReports


Ignore:
Timestamp:
12/24/22 17:25:35 (2 years ago)
Author:
181006
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AdvancedReports

    v46 v47  
    9999  {{{#!sql
    100100select e2."name", q4.max_broj_zainteresirani
    101 from
    102         (
     101from    (
    103102(
    104103        select e.id_event, count(u.id_user) as broj_na_zainteresirani_kupuvaci
     
    136135  {{{#!sql
    137136select q4."location", q4.max_broj_nastani
    138 from
    139         (
    140 
     137from    (
    141138(
    142139        select extract (year from t.date) as godina,
     
    172169  {{{#!sql
    173170select q4."name", q4.surname, q4.max_broj_nastani
    174 from
    175         (
    176 
     171from    (
    177172(
    178173        select u."name", u.surname, count(e.id_event) as broj_nastani
     
    204199{{{#!div style="font-size: 90%"
    205200  {{{#!sql
    206 select u."name", u.surname, count(e.id_event) as broj_nastani 
    207 from artist a 
    208 join users u on a.id_user=u.id_user
    209 join events e on a.id_user=e.id_user_artist
     201select u."name", u.surname, count(e.id_event) as broj_nastani
     202from artist a
     203join users u on a.id_user = u.id_user
     204join events e on a.id_user = e.id_user_artist
    210205where u.id_user in(
    211 select u.id_user
    212 from artist a
    213 join users u on a.id_user=u.id_user
    214 join events e on a.id_user=e.id_user_artist
    215 where e.id_event=1
    216 group by u.id_user)
     206        select u.id_user
     207        from artist a
     208        join users u on a.id_user = u.id_user
     209        join events e on a.id_user = e.id_user_artist
     210        where e.id_event = 1
     211        group by u.id_user)
    217212group by u."name", u.surname
    218213  }}}
     
    223218  {{{#!sql
    224219select u."name", u.surname, r.rating, count(t.id_transaction) as broj_transakcii
    225 from customer c 
    226 join review r on c.id_user=r.id_user_customer
    227 join cart c2 on c.id_user=c2.id_user_customer
    228 join transactions t on c2.id_user_customer=t.id_user_customer
    229 join users u on c.id_user=u.id_user
     220from customer c
     221join review r on c.id_user = r.id_user_customer
     222join cart c2 on c.id_user = c2.id_user_customer
     223join transactions t on c2.id_user_customer = t.id_user_customer
     224join users u on c.id_user = u.id_user
    230225where r.rating >7
    231 group by u."name", u.surname, r.rating 
    232   }}}
    233 }}}
    234 
     226group by u."name", u.surname, r.rating
     227  }}}
     228}}}
     229