Changes between Version 2 and Version 3 of WikiNewPage

Timestamp:

02/05/23 18:28:17 (2 years ago)

Author:

191248

Comment:

--

WikiNewPage

@@ -2 +2 @@
 
 
-== Rename a page #renaming
+== Приказ на договори, склучени во предходните 3 месеци и процечна цена на договор #renaming
 
+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 
 
 ----