Write SQL for top spender and non-spenders

Q: Write SQL for top spender and non-spenders

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.

Q: How do I approach Software Engineering Fundamentals interview questions?

Software Engineering Fundamentals questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master software engineering fundamentals interviews.

Question

Loading...

SQL Questions

Assume the following schema:

users(user_id, created_at, ...)
transactions(txn_id, user_id, amount, txn_ts)
- amount is a positive number for a successful purchase.

Q1: Biggest spender last month

Write a SQL query to find the user(s) with the largest total spend in the previous calendar month.

Q2: Users who never spent

Write a SQL query to find users who have never made a purchase (no rows in transactions).

If you need additional assumptions (timezone, refunds, ties), state them explicitly.

Write SQL for top spender and non-spenders

Quick Overview

SQL Questions

Q1: Biggest spender last month

Q2: Users who never spent

Solution

Comments (0)