Changes between Version 45 and Version 46 of AdvancedReports


Ignore:
Timestamp:
07/22/24 15:47:42 (6 months ago)
Author:
184006
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v45 v46  
    149149    COUNT(CASE WHEN p.typeOfPetsID = (SELECT ID FROM project.type_of_pets WHERE kind_of_pet = 'Cat') THEN 1 END) AS total_cats,
    150150    AVG(CASE WHEN p.typeOfPetsID = (SELECT ID FROM project.type_of_pets WHERE kind_of_pet = 'Dog') THEN EXTRACT(YEAR FROM age(current_date, p.dateOfBirthday)) END) AS avg_age_dogs,
    151     AVG(CASE WHEN p.typeOfPetsID = (SELECT ID FROM proekt.type_of_pets WHERE kind_of_pet = 'Cat') THEN EXTRACT(YEAR FROM age(current_date, p.dateOfBirthday)) END) AS avg_age_cats
     151    AVG(CASE WHEN p.typeOfPetsID = (SELECT ID FROM project.type_of_pets WHERE kind_of_pet = 'Cat') THEN EXTRACT(YEAR FROM age(current_date, p.dateOfBirthday)) END) AS avg_age_cats
    152152FROM
    153153    project.vet_centers vc