SQLize Online / PHPize Online  /  SQLtest Online

select ac.aircraft_code as aircraft_code, model ->> 'ru' as model_ru, model ->> 'en' as model_en, count(flight_id) as flights_count from flights as ac join aircrafts_data as f on f. aircraft_code = ac.aircraft_code where actual_departure::DATE >= date('2017-08-01') and actual_departure::DATE < date('2017-09-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(flight_id) as flights_count from flights as ac join aircrafts_data as f on f. aircraft_code = ac.aircraft_code where actual_departure::DATE >= date(''2017-08-01'') and actual_departure::DATE < date(''2017-09-01'') group by 1,2,3 order by 4 desc');