Сложный запрос в eloquent
Максим11 лет в сервисе
Данные заказчика будут вам доступны после подачи заявки
13.10.2021
Как в eloquent сделать такой запрос ?
SELECT rating,
COUNT(reviews.rating) AS c,
destination_id,
COUNT(reviews.rating) * 100. / (
SELECT COUNT(reviews.rating)
FROM reviews
WHERE rating IS NOT NULL
AND rev_add_rating BETWEEN STR_TO_DATE('2021-09-15 00:00:00', '%Y-%m-%d %H:%i:%s') AND STR_TO_DATE('2021-10-15 00:00:00', '%Y-%m-%d %H:%i:%s')
) AS percent
FROM reviews
WHERE rating IS NOT NULL
AND rev_add_rating BETWEEN STR_TO_DATE('2021-09-15 00:00:00', '%Y-%m-%d %H:%i:%s') AND STR_TO_DATE('2021-10-15 00:00:00', '%Y-%m-%d %H:%i:%s')
GROUP BY rating;