SELECT
s.qty, DATE_FORMAT(s.date, '%Y-%m-%e') AS date,
p.name,SUM(p.sale_price * s.qty) AS total_saleing_price
FROM sales s LEFT JOIN products p
ON s.product_id = p.id
WHERE DATE_FORMAT(s.date, '%Y' ) = '2017'
GROUP BY DATE_FORMAT( s.date, '%c' ), s.product_id
ORDER BY date_format(s.date, '%c' ) ASC