Changes between Version 1 and Version 2 of AdvancedReports


Ignore:
Timestamp:
01/17/22 23:15:09 (3 years ago)
Author:
193026
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TabularUnified AdvancedReports

    v1 v2  
    1818
    1919
    20 == TODO
     20== Приказ на бројот на reviews според reviewer, подредени по опаѓачки редослед
    2121
    2222{{{#!sql
    23  -- TODO
     23 select
     24        rr.reviewer_name,
     25        count(r.review_id) as num_of_reviews_by_reviewer
     26from
     27        review r
     28inner join reviewer rr on
     29        r.reviewer_id = rr.reviewer_id
     30group by rr.reviewer_name
     31order by num_of_reviews_by_reviewer desc
    2432}}}