Changes between Version 1 and Version 2 of AdvancedReports
- Timestamp:
- 01/17/22 23:15:09 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TabularUnified AdvancedReports
v1 v2 18 18 19 19 20 == TODO20 == Приказ на бројот на reviews според reviewer, подредени по опаѓачки редослед 21 21 22 22 {{{#!sql 23 -- TODO 23 select 24 rr.reviewer_name, 25 count(r.review_id) as num_of_reviews_by_reviewer 26 from 27 review r 28 inner join reviewer rr on 29 r.reviewer_id = rr.reviewer_id 30 group by rr.reviewer_name 31 order by num_of_reviews_by_reviewer desc 24 32 }}}