SQLize Online / PHPize Online  /  SQLtest Online

select ac.aircraft_code as aircraft_code, model ->> 'ru' as model_ru, model ->> 'en' as model_en, count(*) as flights_count from aircrafts_data as ac join flights as f on f. aircraft_code = ac.aircraft_code where departure_airport ='DME' and actual_departure::DATE >= date('2017-01-01') and actual_departure::DATE < date('2018-08-01') group by 1,2,3 order by 4 desc ; select * from query_cost('select ac.aircraft_code as aircraft_code, model ->> ''ru'' as model_ru, model ->> ''en'' as model_en, count(*) as flights_count from aircrafts_data as ac join flights as f on f. aircraft_code = ac.aircraft_code where departure_airport =''DME'' and actual_departure::DATE >= date(''2017-01-01'') and actual_departure::DATE < date(''2018-08-01'') group by 1,2,3 order by 4 desc');