Write SQL for top spender and non-spenders
Company: Salesforce
Role: Software Engineer
Category: Software Engineering Fundamentals
Difficulty: medium
Interview Round: Technical Screen
Quick Answer: This question evaluates SQL querying skills including aggregation and grouping, date/time windowing for previous-calendar-month calculations, joins and handling absence of rows to identify top spenders and users with no transactions.