96 | | |
| 95 | === Извештај кој ги прикажува Auditly корисниците кои мониторираат продукти кои имаат помалку просечни месечни рецензии од просекот=== |
| 96 | {{{#!sql |
| 97 | from auditlyuser as au |
| 98 | join review as r |
| 99 | on au.productdomainname = r.productdomainname |
| 100 | where |
| 101 | (select count(rr.id)/count(distinct extract(year_month from r.dateofreview)) as monthlyaverage |
| 102 | from review as rr |
| 103 | where r.productdomainname = rr.productdomainname |
| 104 | group by r.productdomainname |
| 105 | ) > |
| 106 | (select count(rrr.id)/count(distinct extract(year_month from r.dateofreview)) as monthlyaverage |
| 107 | from review as rrr |
| 108 | where r.productdomainname <> rrr.productdomainname |
| 109 | group r.productdomainname |
| 110 | ) |
| 111 | }}} |