Changes between Version 15 and Version 16 of AdvancedApplicationDevelopment

Timestamp:

09/30/25 08:54:44 (2 weeks ago)

Author:

223270

Comment:

--

AdvancedApplicationDevelopment

@@ -243 +243 @@
 === Релациска алгебра
 {{{
-SELECT d.location_name, AVG(r.quality) AS avg_rating FROM destination d JOIN review r ON d.id_destination = r.id_destination GROUP BY d.location_name HAVING AVG(r.quality) > 4;
+SELECT d.location_name, AVG(r.quality) AS avg_rating 
+FROM destination d 
+JOIN review r ON d.id_destination = r.id_destination 
+GROUP BY d.location_name 
+HAVING AVG(r.quality) > 4;