Online PHP editor | output for 8oAA3

@ 2023-04-01T22:33:32Z

<?php

$steps = [
    2500,
    5000,
    10000,
];
for ($i = 0, $count = count($steps); $i < $count; $i++) {
    $step = $steps[$i];
    $previousStepDiff = $step - ($steps[$i-1] ?? $steps[0]) - 1;
    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.19, 8.3.0 - 8.3.7: select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 2500) and (((select max({column}) from {tableName}) - -1)) select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 5000) and (((select max({column}) from {tableName}) - 2499)) select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 10000) and (((select max({column}) from {tableName}) - 4999))

preferences:dark modelive preview