Changes between Version 52 and Version 53 of DatabaseCreation

Timestamp:

06/29/26 22:49:47 (6 days ago)

Author:

231027

Comment:

--

DatabaseCreation

@@ -451 +451 @@
     eh.event_time,
     COUNT(ehr.rating_id) AS total_reviews,
-    ROUND(AVG(ehr.rating), 2) AS average_rating
+    COALESCE(ROUND(AVG(ehr.rating), 2), 0.00) AS average_rating
 FROM "Event" e
 JOIN "Event_Happening" eh ON e.event_id = eh.event_id
-JOIN "Event_Happening_Rating" ehr ON eh.event_happening_id = ehr.event_happening_id
+LEFT JOIN "Event_Happening_Rating" ehr ON eh.event_happening_id = ehr.event_happening_id
 GROUP BY e.event_id, e.name, eh.event_happening_id, eh.event_time;