select u.company_name, dc.city_code, ac.city_code, psa.available_seats, psa.flight_date

from flights f
join cities dc on dc.id = f.departure_city_id
join cities ac on ac.id = f.arrival_city_id
join users u on u.id = f.user_id
join planwise_seat_availabilities psa on psa.flight_id = f.id

where psa.flight_date = "2023-03-30" and psa.available_seats > 0
order by u.company_name asc