Back to problems

Monthly Sales Growth

SQL · DoorDash · Easy

Table orders table: Column Name Type order_id int customer_id int restaurant_id int order_date date order_amount float order_id is the primary key. Each row represents a single order placed by a customer. Task For every month in 2021, calculate the month-over-month sales growth percentage using the formula: (sales - prev_month_sales) / prev_month_sales * 100 Round the result to two decimal places. The first month has no preceding month, so both prev_month_sales and…

Checking your access…