Consecutive Trades Within Threshold

HardWindow FunctionsLag/LeadDate Functions

Problem

Given a table of transactional data at Castleton Commodities International, identify users or accounts that have executed consecutive trades within a specific millisecond threshold.

Problem

Given a table of transactional data at Castleton Commodities International, identify users or accounts that have executed consecutive trades within a specific millisecond threshold.

Your answer

Try one AI text evaluation on us

Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.

0 wordstarget ~200

Up next

First Trade Per ClientMedium

SQL for High-Value Rolling WindowHard

SQL Window Query for 5-Minute BurstsHard

Next question

All questions/SQL & Data Manipulation

Consecutive Trades Within Threshold

HardWindow FunctionsLag/LeadDate Functions

Problem

Given a table of transactional data at Castleton Commodities International, identify users or accounts that have executed consecutive trades within a specific millisecond threshold.

Problem

Given a table of transactional data at Castleton Commodities International, identify users or accounts that have executed consecutive trades within a specific millisecond threshold.

Your answer

Try one AI text evaluation on us

Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.

0 wordstarget ~200

Up next

First Trade Per ClientMedium

SQL for High-Value Rolling WindowHard

SQL Window Query for 5-Minute BurstsHard

Next question