Loading this exercise…

Calculate monthly ecommerce net sales

#1 · 1 of 5Free sample

Instructions

Calculate monthly ecommerce net sales

A commerce team needs monthly net sales for completed orders using ecommerce_orders and ecommerce_refunds. Net sales equals gross_amount minus discount_amount minus every refund linked to the order, including refunds processed in a later month. Aggregate refunds before joining so orders with multiple refunds are not duplicated.

Return exactly two columns: month in YYYY-MM format and net_sales rounded to 2 decimals. Return one row per order month, ordered by month.

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

A free account records your attempt and then reveals the reference answer and the explanation for every exercise in the library.

Reference answer + explanation revealed after each attempt
Progress saved on the platform
1,598 graded exercises
Free forever — no credit card
The GPT tutor is part of the course, not the free tier

Create free account →Already a member? Log in →

All exercises in Free Dataset Analysis

customer_id

INTEGER NOT NULL

order_dateTEXT NOT NULL

statusTEXT NOT NULL

gross_amountREAL NOT NULL

discount_amountREAL NOT NULL

ecommerce_refunds4 cols

refund_idINTEGER PRIMARY KEY
order_idINTEGER NOT NULL
refund_dateTEXT NOT NULL
refund_amountREAL NOT NULL

subscription_accounts2 cols

account_idINTEGER PRIMARY KEY
started_onTEXT NOT NULL

subscription_events5 cols

event_idINTEGER PRIMARY KEY
account_idINTEGER NOT NULL
event_dateTEXT NOT NULL
event_typeTEXT NOT NULL
plan_mrrREAL NOT NULL

campaign_imports6 cols

import_idINTEGER PRIMARY KEY
campaign_idTEXT
activity_dateTEXT NOT NULL
channelTEXT NOT NULL
spend_usdREAL NOT NULL
conversionsINTEGER NOT NULL

inventory_opening2 cols

product_idINTEGER PRIMARY KEY
opening_unitsINTEGER NOT NULL

inventory_movements5 cols

movement_idINTEGER PRIMARY KEY
product_idINTEGER NOT NULL
movement_dateTEXT NOT NULL
movement_typeTEXT NOT NULL
quantity_changeINTEGER NOT NULL

bike_hourly6 cols

observation_idINTEGER PRIMARY KEY
ride_dateTEXT NOT NULL
hourINTEGER NOT NULL
working_dayINTEGER NOT NULL
seasonTEXT NOT NULL
rentalsINTEGER NOT NULL

Tables

8 tables

ecommerce_orders6 cols

order_idINTEGER PRIMARY KEY
customer_idINTEGER NOT NULL
order_dateTEXT NOT NULL
statusTEXT NOT NULL
gross_amountREAL NOT NULL
discount_amountREAL NOT NULL