Changes between Version 44 and Version 45 of AdvancedReports


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

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v44 v45  
    146146SELECT
    147147    vc.name AS vet_center_name,
    148     COUNT(CASE WHEN p.typeOfPetsID = (SELECT ID FROM proekt.type_of_pets WHERE kind_of_pet = 'Dog') THEN 1 END) AS total_dogs,
    149     COUNT(CASE WHEN p.typeOfPetsID = (SELECT ID FROM proekt.type_of_pets WHERE kind_of_pet = 'Cat') THEN 1 END) AS total_cats,
    150     AVG(CASE WHEN p.typeOfPetsID = (SELECT ID FROM proekt.type_of_pets WHERE kind_of_pet = 'Dog') THEN EXTRACT(YEAR FROM age(current_date, p.dateOfBirthday)) END) AS avg_age_dogs,
     148    COUNT(CASE WHEN p.typeOfPetsID = (SELECT ID FROM project.type_of_pets WHERE kind_of_pet = 'Dog') THEN 1 END) AS total_dogs,
     149    COUNT(CASE WHEN p.typeOfPetsID = (SELECT ID FROM project.type_of_pets WHERE kind_of_pet = 'Cat') THEN 1 END) AS total_cats,
     150    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,
    151151    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
    152152FROM