Changes between Version 4 and Version 5 of WikiNewPage

Timestamp:

02/05/23 18:29:22 (2 years ago)

Author:

191248

Comment:

--

WikiNewPage

@@ -6 +6 @@
 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() 
+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