Changes between Version 11 and Version 12 of AdvancedApplicationDevelopment

Timestamp:

09/25/25 13:28:20 (3 weeks ago)

Author:

223270

Comment:

--

AdvancedApplicationDevelopment

@@ -92 +92 @@
 GROUP BY d.id_destination, d.location_name
 ORDER BY procent_cheap DESC;
-}}}
-
-{{{
- DB::statement("
-            CREATE VIEW view_procent_cheap_destinations AS
-            SELECT
-                d.imelokacija,
-                COUNT(CASE WHEN a.iznos < 500 THEN 1 END) * 100.0 / COUNT(*) AS procent_cheap
-            FROM travel_sage.destinacii d
-            JOIN travel_sage.aktivnosti a ON d.iddest = a.iddest
-            GROUP BY d.iddest, d.imelokacija
-            ORDER BY procent_cheap DESC
-        ");
 }}}