Search
⌘K
Get Premium
Leetcode 2329. Product Sales Analysis V
Given product and sales tables, write an SQL query that joins and aggregates sales per product to produce a summarized metric (e.g., total sales or count) and then filter or rank products to satisfy a specified condition (such as top seller(s) or products with no sales). Expect to use GROUP BY with aggregate functions, HAVING or window functions and handle missing/null sales via outer joins.
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.