Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/10/24 10:17:08 (12 months ago)

Author:

184006

Comment:

--

AdvancedReports

@@ -43 +43 @@
   project.pets p;
 }}}
+== Прикажување на држава која е најчест производител на лекови.
+{{{
+ select
+        state as country,
+        COUNT(*) as most_common_manufacturer
+from
+        project.manufacturers
+group by
+        state
+order by
+        most_common_manufacturer desc
+limit 1;
+}}}