Skip to main content
All Questions

Find Monthly Revenue Growth

Hard
Unlock detailed company stats for this questionUpgrade

You are given the following tables:

orders table:

order_idcustomer_idorder_dateorder_amountdepartment_id
integerintegerdateintegerinteger

departments table:

department_iddepartment_name
integerstring

customers table:

customer_idfirst_namelast_name
integerstringstring

Find the department with the highest month-on-month increase (order amount) in December 2022. Your output should have the following columns: department_id, department_name, mom_increase

Interview experiences

1 shared
Uber · a year ago
"The process was straightforward. Recruiter set the expectations of each round early in the process. The interviewers were very candid and professional, with straight focus on case solving using MECE and structured thinking"
BizOps & Strategy · Entry Level / L3

Related questions

Find Revenue by Department

Related courses

Course

Product Strategy Questions

Product strategy is fundamentally different in the AI era, and we'll tell you exactly how to approach these rounds effectively within the new rules.

Course

BizOps & Strategy Interview Prep

Land your dream operations and strategy role at Google, Meta, Amazon, Uber, Microsoft, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice strategic decision-making, stakeholder management, product strategy, analytics, and behavioral interviews.