Changes between Version 46 and Version 47 of AdvancedReports
- Timestamp:
- 12/24/22 17:25:35 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AdvancedReports
v46 v47 99 99 {{{#!sql 100 100 select e2."name", q4.max_broj_zainteresirani 101 from 102 ( 101 from ( 103 102 ( 104 103 select e.id_event, count(u.id_user) as broj_na_zainteresirani_kupuvaci … … 136 135 {{{#!sql 137 136 select q4."location", q4.max_broj_nastani 138 from 139 ( 140 137 from ( 141 138 ( 142 139 select extract (year from t.date) as godina, … … 172 169 {{{#!sql 173 170 select q4."name", q4.surname, q4.max_broj_nastani 174 from 175 ( 176 171 from ( 177 172 ( 178 173 select u."name", u.surname, count(e.id_event) as broj_nastani … … 204 199 {{{#!div style="font-size: 90%" 205 200 {{{#!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_user209 join events e on a.id_user =e.id_user_artist201 select u."name", u.surname, count(e.id_event) as broj_nastani 202 from artist a 203 join users u on a.id_user = u.id_user 204 join events e on a.id_user = e.id_user_artist 210 205 where u.id_user in( 211 select u.id_user 212 from artist a 213 join users u on a.id_user=u.id_user214 join events e on a.id_user=e.id_user_artist215 where e.id_event=1216 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) 217 212 group by u."name", u.surname 218 213 }}} … … 223 218 {{{#!sql 224 219 select 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_customer227 join cart c2 on c.id_user =c2.id_user_customer228 join transactions t on c2.id_user_customer =t.id_user_customer229 join users u on c.id_user =u.id_user220 from customer c 221 join review r on c.id_user = r.id_user_customer 222 join cart c2 on c.id_user = c2.id_user_customer 223 join transactions t on c2.id_user_customer = t.id_user_customer 224 join users u on c.id_user = u.id_user 230 225 where r.rating >7 231 group by u."name", u.surname, r.rating 232 }}} 233 }}} 234 226 group by u."name", u.surname, r.rating 227 }}} 228 }}} 229