Changes between Version 7 and Version 8 of WikiNewPage

Timestamp:

02/05/23 18:31:10 (17 months ago)

Author:

191248

Comment:

--

WikiNewPage

@@ -5 +5 @@
 {{{#!sql
 select distinct count(d.iddog) as broj_dogovori, avg(cenadog) as procena_cena 
-
 from dogovori d 
-
 left join rezervacii r on
-
 r.iddog=d.iddog
-
 left join smetki s on
-
 s.iddog=d.iddog 
-
 where
-
 sklucenna between now() - interval '3 months' and now() 
-
-
 group by d.iddog 
 }}}