• (Sorry, response in English) If I understand the Google translate correctly, you'll need to add something to your query to also include the sales from a year ago. Here's a pseudo-code example:

    SELECT

    sale_date

    ,SUM([Amount sale]) as Sales

    FROM sales

    WHERE sale_date = @date

    OR sale_date = DATEADD(YEAR, -1, @date)

    GROUP BY sale_date