Объясните пожалуйста, почему скрипты не работает

with cte as (

select

date_trunc('month', bookings.book _date) as mnth,

count (*) as cnt,

sum ( bookings.total _amount) as total

from bookings.bookings b

group by 1

)


select mnth, cnt, total from cte

where cnt * total

where cnt * total = (select max(cnt*total) from cte)

or cnt * total = (select min(cnt*total) from cte)

from cte


with cte as (

select t.ticket_no, f.departure_airport, f.arrival_airport, f.sceduled_deparute, f.sceduled_arrival

from bookings.tickets t

join bookings.ticket t on tf._no = t.ticket_no

join bookings.flights f on f.flight_id = tf.flight_id

)



select distinct a1.city as city_departure, a2.city as city_arrival

from cte as tb1

join cte as tb2 on t2.ticket_no = t1.ticket_no and t1.arrival_airport = t2.departure_airport and t2.scheduled_departure - t1.scheduled_arrival < 24

join bookings.airports as a1 on t1.departure_airport = a1.airport_code

join bookings.airports as a2 on t2.arrival_airport = a2.airport_code