Changes between Version 11 and Version 12 of AdvancedReports


Ignore:
Timestamp:
03/06/23 15:58:32 (19 months ago)
Author:
201087
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v11 v12  
    3232select
    3333        extract (year from date_posted) as year,
    34         SUM(postid) as number_of_posts_student,
     34        COUNT(postid) as number_of_posts_student,
    3535        (
    3636                select
    3737                       
    38                         SUM(postid) as number_of_posts_owner
     38                        COUNT(postid) as number_of_posts_owner
    3939                        from post p
    4040                        join owner_post op on op.owner_postid = p.postid