Online PHP editor | output for JqfUn

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

<?php

$steps = [
    2500,
    5000,
    10000,
];
for ($i = 0, $count = count($steps); $i < $count; $i++) {
    $step = $steps[$i];
    $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}) - 2500) and (((select max({column}) from {tableName}) - 0)) select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 5000) and (((select max({column}) from {tableName}) - 2500)) select avg(requestTimeSec) from {tableName} where {column} between ((select max({column}) from {tableName}) - 10000) and (((select max({column}) from {tableName}) - 5000))

preferences:dark modelive preview