Changes between Version 1 and Version 2 of AdvancedReports

Timestamp:

01/10/24 09:28:23 (6 months ago)

Author:

184006

Comment:

--

AdvancedReports

@@ -9 +9 @@
 LIMIT 1;
 }}}
+== Прикажување која раса е најчесто застапена.
+{{{
+SELECT b.name AS breed_name, COUNT(p.ID) AS pet_count
+FROM project.breeds b
+JOIN project.type_of_pets t ON b.ID = t.ID
+JOIN project.pets p ON t.ID = p.typeOfPetsID
+GROUP BY b.ID
+ORDER BY pet_count DESC
+LIMIT 1;
+}}}