Changes between Version 2 and Version 3 of AdvancedReports

Timestamp:

12/23/22 13:10:41 (3 years ago)

Author:

181213

Comment:

--

AdvancedReports

@@ -2 +2 @@
 
 - Ресторан со најмногу нарачки за последниот Х период?
+{{{#!sql
+SELECT q1.restoran_ime 
+FROM(
+SELECT r.restoran_ime, COUNT(n.naracka_id) as naracki
+FROM restoran as r
+JOIN meni as m on r.restoran_id=m.restoran_id 
+JOIN obrok as o on m.meni_id=o.meni_id 
+JOIN se_sostoi_od as sso on o.obrok_id=sso.obrok_id 
+JOIN naracka as n on sso.naracka_id=n.naracka_id 
+GROUP BY r.restoran_ime) q1
+WHERE q1.naracki=(SELECT MAX(naracki)FROM (
+SELECT r.restoran_ime, COUNT(n.naracka_id) as naracki
+FROM restoran as r
+JOIN meni as m on r.restoran_id=m.restoran_id 
+JOIN obrok as o on m.meni_id=o.meni_id 
+JOIN se_sostoi_od as sso on o.obrok_id=sso.obrok_id 
+JOIN naracka as n on sso.naracka_id=n.naracka_id 
+GROUP BY r.restoran_ime) q1
+)
+}}}
 - Најголем профит?
 - Најнарачан производ по ресторан?