Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

01/01/23 21:47:11 (3 years ago)

Author:

181213

Comment:

--

AdvancedReports

@@ -44 +44 @@
 )q2)
 }}}
-- Најнарачан производ по ресторан сортиран?
+- Најнарачан производ по ресторан сортиран
+{{{#!sql
+select q1.restoran_ime as restoran, MAX(q1.obrok_ime) as obrok, MAX(q1.br_obroci) as broj_naracki FROM(
+SELECT r.restoran_ime, o.obrok_ime,  SUM(sso.kolicina) as br_obroci
+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, o.obrok_ime)q1
+group by restoran
+order by broj_naracki desc
+}}}
 - Кој корисник колку има платено во секој ресторан подредено?