Hello, I need a query for the yearly sales from the orders (ORDR), compared to last years sales. Preferrebly per quarter or per month. But i want the query to be refreshing as time goes on and don't want to set a specific timeperiod to see the list...

Im creating a query for an invoice intake revenue and want to compare the revenue of the invoices from last week with the revenue of the week before the last week. But I'm stuck with mij SQL-code. Help is needed, thanks