-- VIEW
CREATE OR REPLACE VIEW v_Schedule_Since_Last_Month AS
  SELECT
    a.name,
    s.*,
    f_get_passengers_between_dates(a.code, (date_trunc('month', now()) - interval '1 month')::DATE, (date_trunc('month', now()) - interval '1 day')::DATE) AS passengers_last_month
  FROM
    airlines a
  INNER JOIN
    flights f ON (a.code = f.airline_code)
  INNER JOIN
    f_get_schedule_by_date(now()::DATE) s ON (f.flight_number = s.flight_number);