Help with query

Hello,

Sorry I'm not excellent in SQL and I need to write a plain sql query to get me the top 5 rated places by calculating the average rating for all services.

My tables

PLACE Table

• id
• country_id
• is_active
• name

RATING

• id
• place_id
• service_id
• rating

I tried the below but it throws an error:

$sql = "SELECT p.id as id, p.name as name, avg(r.rating) as rating FROM place p, rating r WHERE r.place_id = p.id AND p.country_id = 99 AND p.is_active = 1 GROUP BY r.place_id"; $results = DB::select($sql);