Interview Questions Interview Guides Experiences Mock Interviews Pricing

Interview Guides

Calculate Monthly Sales Growth by Product Category | Dataford Interview Questions

All questions/SQL & Data Manipulation

Asked 1mo ago|

Wayfair

Calculate Monthly Sales Growth by Product Category

MediumJoinsAggregations

Problem

A retail company needs to analyze its sales performance. Write a SQL query to calculate the month-over-month sales growth for each product category.

Requirements

Join the sales and products tables by product_id.
Calculate total sales per category for each month.
Determine the month-over-month growth percentage for each category.
Order the results by category and month.

Problem

A retail company needs to analyze its sales performance. Write a SQL query to calculate the month-over-month sales growth for each product category.

Requirements

Join the sales and products tables by product_id.
Calculate total sales per category for each month.
Determine the month-over-month growth percentage for each category.
Order the results by category and month.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Total Wine & More

Monthly Sales Trends by CategoryMedium

Walgreens

Monthly Sales Aggregation by Product CategoryMedium

Zulily

Analyze Monthly Revenue Trends by Product CategoryMedium