Changes between Version 31 and Version 32 of AdvancedReports

Timestamp:

07/22/24 14:27:31 (6 months ago)

Author:

184006

Comment:

--

AdvancedReports

@@ -54 +54 @@
     GROUP BY
         pet_id
+),
+
+PetsWithMaxReports AS (
+    SELECT
+        pet_id,
+        max_reports_count
+    FROM
+        MaxReportsPerPet
+    WHERE
+        max_reports_count = (SELECT MAX(max_reports_count) FROM MaxReportsPerPet)
 )
 
@@ -64 +74 @@
     DoctorPetReportsCount dprc
 JOIN
-    MaxReportsPerPet mrpp ON dprc.pet_id = mrpp.pet_id AND dprc.reports_count = mrpp.max_reports_count
-JOIN
-    project.users u ON dprc.doctor_id = u.id
-WHERE
-    dprc.pet_id = (SELECT pet_id FROM MaxReportsPerPet ORDER BY max_reports_count DESC LIMIT 1);
+    PetsWithMaxReports pwmr ON dprc.pet_id = pwmr.pet_id AND dprc.reports_count = pwmr.max_reports_count
+JOIN
+    project.users u ON dprc.doctor_id = u.id;
+
 }}}
 == За секое прашање кое е поставено во Blog Post For Consultations колку одговори има, од кои корисници се дадени одговорите и каква е улогата на корисниците кои одговориле(admin, manager, employee, standard).