Practice Meta SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Identify sellers with more than three distinct products that each exceeded a specific interaction volume threshold.
Restrict analysis to products explicitly listed in the dimension table.
Perform nested aggregations to filter at both the product-seller level and the seller level.

What This Tests

Multi-level data aggregation and filtering
Using dimension tables to validate transactional data
Applying conditional filters after grouping
Counting distinct qualifying entities across hierarchical thresholds

Common Patterns

Inner Join

Groupby

Aggregation

HAVING Filter

Test Cases

Input

-

Output

-

Expected

-