SQLize Online / PHPize Online  /  SQLtest Online

select date_trunc('minute',avg(f.delay)) as average_departure_delay, max(f.delay) as maximal_departure_delay from (select scheduled_departure, actual_departure, actual_departure - scheduled_departure as delay from flights where departure_airport = 'DME' and actual_departure::date between '2017-08-01' AND '2017-08-31' and actual_departure is not null) f ; select * from query_cost('select date_trunc(''minute'',avg(f.delay)) as average_departure_delay, max(f.delay) as maximal_departure_delay from (select scheduled_departure, actual_departure, actual_departure - scheduled_departure as delay from flights where departure_airport = ''DME'' and actual_departure::date between ''2017-08-01'' AND ''2017-08-31'' and actual_departure is not null) f');