Search
⌘K
Get Premium
Leetcode 1821. Find Customers With Positive Revenue this Year
Given customer and revenue tables, return the customers who had total revenue > 0 in the specified year. This is an easy SQL task focusing on JOINs (or direct filtering), optional aggregation (GROUP BY) to sum revenues, and filtering out zero or missing values.
Question Timeline
See when this question was last asked and where, including any notes left by other candidates.
All Regions
Comments
Hello Interview Premium
Your account is free and you can post anonymously if you choose.