SQL Practice Logo

SQLPractice Online

Level 8 - PrincipalQuery-Based Questionsm1 distributed data architecture

Region-Partition Product Reads

Interviewer prompt: catalog_reads is partitioned by region/date. Return top 20 product_id by reads for us-east today.

Schema Context

catalog_reads(product_id, region, read_date, read_count)