Changes between Version 14 and Version 15 of AdvancedReports

Timestamp:

07/10/23 18:27:14 (12 months ago)

Author:

201144

Comment:

--

AdvancedReports

@@ -32 +32 @@
 {{{
 select 
-        extract (year from date_posted) as year,
+        extract (year from dateposted) as year,
         COUNT(postid) as number_of_posts_student,
         (
@@ -39 +39 @@
                         COUNT(postid) as number_of_posts_owner
                         from post p
-                        join owner_post op on op.owner_postid = p.postid 
+                        join owner_post op on op.ownerpostid = p.postid 
                         
         )
 from post p
-join student_post sp on sp.student_postid = p.postid
-group by extract (year from date_posted)
+join student_post sp on sp.studentpostid = p.postid
+group by extract (year from dateposted)
 }}}
 * Објавите на газдите и која е разликата меѓу цената објавена и цената потпишана за станот, и колку вкупно имаат заработено во тој договор.