Sort all monthly incomes and group by year I want to show all my monthly incomes and group them yearly, like in the picture below.
The query is like 

SELECT 
monthname(date_added) as monthno,
year(date_added) as year,
SUM(amount) as amounts 
FROM incomes GROUP BY year ORDER BY monthno


but it groups yearly and hides months of the year:



screenshot
Quick solution:

SELECT MONTH(date) AS monthno
     , SUM(amount) AS monthsum
  FROM incomes 
 GROUP BY monthno 
 ORDER BY monthno
;


More date functions are available for getting a text version of the date.