PracHub
QuestionsLearningGuidesInterview Prep
|Home/Software Engineering Fundamentals/Salesforce

Write SQL for top spender and non-spenders

Last updated: Mar 29, 2026

Quick Overview

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.

  • medium
  • Salesforce
  • Software Engineering Fundamentals
  • Software Engineer

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.

Related Interview Questions

  • Choose DynamoDB vs MySQL for a backend - Salesforce (medium)
  • How do you perform a thorough code review? - Salesforce (hard)
  • Design an Elevator Control System - Salesforce (easy)
|Home/Software Engineering Fundamentals/Salesforce

Write SQL for top spender and non-spenders

Salesforce logo
Salesforce
Jan 22, 2026, 12:00 AM
mediumSoftware EngineerTechnical ScreenSoftware Engineering Fundamentals
7
0
Loading...
Loading comments...

Browse More Questions

More Software Engineering Fundamentals•More Salesforce•More Software Engineer•Salesforce Software Engineer•Salesforce Software Engineering Fundamentals•Software Engineer Software Engineering Fundamentals

Write your answer

Your first approved answer each day earns 20 XP.

Sign in to write your answer.
PracHub

Master your tech interviews with 9,000+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • AI Coding Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.