Добавил:
itan_hunt
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:q10
.sql SELECT
sale.id AS sale_id,
good.name AS good_name,
(sale.sale_sum * good.price) AS profit
FROM sale
INNER JOIN sale_has_good
ON sale_has_good.sale_id = sale.id
INNER JOIN good
ON good.id = sale_has_good.good_id
ORDER BY profit DESC
LIMIT 5;
sale.id AS sale_id,
good.name AS good_name,
(sale.sale_sum * good.price) AS profit
FROM sale
INNER JOIN sale_has_good
ON sale_has_good.sale_id = sale.id
INNER JOIN good
ON good.id = sale_has_good.good_id
ORDER BY profit DESC
LIMIT 5;