SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedQuery-Based Questionsm5 distributed sql sharding consistency

Cross-Shard Transaction Frequency

Write SQL to return txn_id and shard_count for transactions touching more than 1 shard in the last 6 hours.

Schema Context

txn_shard_events(txn_id, shard_id, event_ts)