Changes between Version 22 and Version 23 of AdvancedReports

Timestamp:

01/10/23 21:48:34 (3 years ago)

Author:

201235

Comment:

--

AdvancedReports

@@ -115 +115 @@
 
 == Прашалник 3
-(text here)
-{{{#!sql
---sql here
+За секоја храна, бројот на миленици кои ја јадат таа храна кои имаат ниска физичка активност и примаат терапии.
+{{{#!sql
+select 
+        food.name_food as food_name,
+        sum(q2.has_therapies) as total_pets
+from 
+        (
+        select 
+        q1.pet_id,
+        q1.has_therapies
+        from 
+                (
+                        select
+                                pet.id_pet as pet_id,
+                                count(therapy.id_therapy) as has_therapies
+                        from 
+                                pet
+                        join
+                                pet_needs_therapy pnt 
+                                on pnt.id_pet = pet.id_pet 
+                        join
+                                therapy
+                                on therapy.id_therapy = pnt.id_therapy 
+                        group by 
+                                pet.id_pet
+                ) as q1
+                join personal_profile  
+                        on q1.pet_id = personal_profile.id_pet
+                where 
+                        personal_profile.physical_activity = 0
+        ) as q2
+join pet_preferably_eats_food ppef 
+        on ppef.id_pet = q2.pet_id
+join food
+        on food.id_food = ppef.id_food
+group by 
+        food.id_food 
+order by 
+        total_pets
 }}}