Create a database query to calculate the total sales in the past week.
Table name = sales
SELECT SUM(amount) as weekly_sales FROM sales WHERE sales_date >= DATEADD(day, -7, GETDATE());
Complete the following task based on the instruction and optional input provided.### Instruction:
Create a database query to calculate the total sales in the past week.

### Input:
Table name = sales

### Output:
SELECT SUM(amount) as weekly_sales FROM sales WHERE sales_date >= DATEADD(day, -7, GETDATE());