Changes between Version 1 and Version 2 of AdvancedReports


Ignore:
Timestamp:
01/11/23 02:29:04 (18 months ago)
Author:
201087
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v1 v2  
    44
    55{{{
    6 select stud.studentid, appus.ime, appus.prezime, b.cityname, b.building_adress, apt.apartment_adress, aa.date_signed,apt.apartmentid,aa.date_signed,aa.date_expires, count(apt.apartmentid) as kolku_pati, extract(month from age(aa.date_expires,aa.date_signed)) * sum(aa.apartment_rent)  as vkupno_plateno  from apartment_agreement as aa
     6select stud.studentid, appus.ime, appus.prezime, b.cityname, b.building_adress,
     7apt.apartment_adress, aa.date_signed,apt.apartmentid,aa.date_signed,aa.date_expires,
     8count(apt.apartmentid) as kolku_pati,
     9extract(month from age(aa.date_expires,aa.date_signed)) * sum(aa.apartment_rent)  as vkupno_plateno  from apartment_agreement as aa
    710join apartment apt on apt.apartmentid = aa.apartmentid
    811join student_signs ss on ss.agreementid = aa.apartment_agreementid