SELECT DATE(ord.created_at) AS order_date,
COUNT(*) AS cnt,
SUM(op.price  * op.amount) AS sum_price,
SUM(op.amount) AS sum_amount
FROM orderhasproduct op
INNER JOIN 'order' ord
ON op.order_id = ord.order_id
GROUP BY DATE(ord.created_at);