hope you are all well
I am struggling to write a sql code on the table below, in a nutshell i just need to pick up the last date of the months data and show that only
e.g i have this table
and i am trying to write a code that will show the sales only of the last date of each month so the results should be as below
can this be done?