Company SQL Question

Seller Revenue and Performance Dashboard

Practice this Amazon style SQL interview question with live execution and instant feedback.

Problem Statement

Create a comprehensive seller performance report showing seller name, total products sold, total revenue, average product rating, and revenue rank. Include only sellers with at least 2 products sold. Use a window function to rank sellers by revenue.

Relevant Tables

sellersproductsorder_itemsreviews

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
Window Functions FundamentalsWindow Functions
COUNT, SUM, AVG, MIN, MAXAggregate Functions & Grouping