SELECTDAYNAME(Created) AS theday,SUM(price) AS thesum
FROM mytable
GROUP BY DAYNAME(Created)
ORDER BY Created asc LIMIT 7;