Changes between Version 24 and Version 25 of AdvancedApplicationDevelopment

Timestamp:

09/30/25 09:43:44 (2 weeks ago)

Author:

223270

Comment:

--

AdvancedApplicationDevelopment

@@ -25 +25 @@
 SELECT * FROM activity
 WHERE start_date >= '2025-01-01' AND end_date <= '2025-12-31';
+}}}
+
+{{{
+EXPLAIN ANALYZE
+SELECT d.location_name, AVG(r.quality)
+FROM destination d
+JOIN activity a ON d.id_destination = a.id_destination
+JOIN review r ON a.id_activity = r.id_activity
+WHERE a.amount < 500
+GROUP BY d.location_name;
 }}}