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.