Changes between Version 17 and Version 18 of AdvancedReports

Timestamp:

01/22/22 10:08:57 (2 years ago)

Author:

196021

Comment:

--

AdvancedReports

@@ -149 +149 @@
  from 
  (
-      select * from 
-      (
-          select q1.godina as god , max(q1.broj_odrzani_filmovi) as maksimum from 
-          ( 
-             select extract(year from r.reservation_date)as godina ,r.reservation_id as rez ,count(r.projection_id) as broj_odrzani_filmovi
-             from reservation as r
-             join seat as s2 on r.seat_id=s2.seat_id
-             join auditorium as a2 on s2.auditorium_id=a2.auditorium_id
-             join movieprojection as mp1 on r.projection_id=mp1.projection_id
-             group by 1,2
-          )q1
-          group by godina
+  select * from 
+  (
+    select q1.godina as god , max(q1.broj_odrzani_filmovi) as maksimum from 
+   ( 
+     select extract(year from r.reservation_date)as godina ,r.reservation_id as rez ,count(r.projection_id) as broj_odrzani_filmovi
+     from reservation as r
+     join seat as s2 on r.seat_id=s2.seat_id
+     join auditorium as a2 on s2.auditorium_id=a2.auditorium_id
+     join movieprojection as mp1 on r.projection_id=mp1.projection_id
+     group by 1,2
+ ) as q1
+    group by godina
         
-      )q2
+ ) as q2
       join 
-      (
+ (
       select extract (year from r.reservation_date)as godina , r.reservation_id as rez,count(r.projection_id) as broj_odrzani_filmovi
       from reservation as r
-             join seat as s3 on r.seat_id=s3.seat_id
-             join auditorium as a3 on s3.auditorium_id=a3.auditorium_id
-             join movieprojection as mp2 on r.projection_id=mp2.projection_id
-             group by 1,2
-      )q3
-       on q2.god=q3.godina and q2.maksimum=q3.broj_odrzani_filmovi
+      join seat as s3 on r.seat_id=s3.seat_id
+      join auditorium as a3 on s3.auditorium_id=a3.auditorium_id
+      join movieprojection as mp2 on r.projection_id=mp2.projection_id
+      group by 1,2
+ )as q3
+  on q2.god=q3.godina and q2.maksimum=q3.broj_odrzani_filmovi
  
- ) q4
+ )as q4
 
  join( select distinct r3.reservation_id, count(r3.projection_id) as vkupno
-         from reservation as r3
-          join movieprojection as mp5 on r3.projection_id=mp5.projection_id 
-          join movie as m4 on mp5.movie_id=m4.movie_id
-          group by 1
+   from reservation as r3
+   join movieprojection as mp5 on r3.projection_id=mp5.projection_id 
+   join movie as m4 on mp5.movie_id=m4.movie_id
+   group by 1
  )as vkupna_brojka on vkupna_brojka.vkupno is not null