The conversation between human and AI assistant.
[|Human|] Create a database query to calculate the total sales in the past week.
[|AI|] SELECT SUM(amount) as weekly_sales FROM sales WHERE sales_date >= DATEADD(day, -7, GETDATE());
[|Human|] 
Create a database query to calculate the total sales in the past week.