Changes between Version 6 and Version 7 of WikiNewPage

Timestamp:

02/05/23 18:30:52 (2 years ago)

Author:

191248

Comment:

--

WikiNewPage

@@ -4 +4 @@
 == Приказ на договори, склучени во предходните 3 месеци и процечна цена на договор #renaming
 {{{#!sql
-select distinct count(d.iddog) as broj_dogovori, avg(cenadog) as procena_cena \\
+select distinct count(d.iddog) as broj_dogovori, avg(cenadog) as procena_cena 
 
-from dogovori d \\
+from dogovori d 
 
-left join rezervacii r on\\
+left join rezervacii r on
 
-r.iddog=d.iddog\\
+r.iddog=d.iddog
 
-left join smetki s on\\
+left join smetki s on
 
-s.iddog=d.iddog \\
+s.iddog=d.iddog 
 
-where\\
+where
 
-sklucenna between now() - interval '3 months' and now() \\
+sklucenna between now() - interval '3 months' and now()