How to solve the problem with aliases?

Question

SQL

SELECT
    `products`.*,
    AVG(product_ratings.rating) AS `total_rating`
FROM
    `products`
LEFT JOIN `products` ON products.id = product_ratings.product_id
WHERE
    `products`.`slug` = 'organization-idorganization-idorganization-idorganization-id-1'

Answer 1

Add grouping to the query
GROUP BY products.id
and ask a more specific question.