Online PHP editor | output for 6InU2

@ 2023-04-01T22:35:34Z

<?php

$steps = [
    2500,
    5000,
    10000,
];
for ($i = 0, $count = count($steps); $i < $count; $i++) {
    $step = $steps[$i] + 1;
    $previousStepDiff = $step - ($steps[$i-1] ?? $steps[0]);
    echo <<<sql
    select avg(requestTimeSec)
    from {tableName}
    where {column} between ((select max({column}) from {tableName}) - {$step}) and (((select max({column}) from {tableName}) - {$previousStepDiff}))
    
    sql;
}

Output for 8.0.1 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6: select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 2501) and (((select max({column}) from {tableName}) - 1)) select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 5001) and (((select max({column}) from {tableName}) - 2501)) select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 10001) and (((select max({column}) from {tableName}) - 5001))

preferences:dark modelive preview