Changes between Version 5 and Version 6 of QueryOptimization


Ignore:
Timestamp:
04/26/26 15:07:41 (6 days ago)
Author:
231027
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • QueryOptimization

    v5 v6  
    8686    eh.event_time,
    8787    COUNT(ehr.rating_id) AS total_reviews,
    88     ROUND(AVG(ehr.rating), 2) AS average_rating
     88    AVG(ehr.rating) AS average_rating
    8989FROM "Event" e
    9090JOIN "Event_Happening" eh ON e.event_id = eh.event_id