Re: 請提供DebConf住宿資料 (Please provide start date / end date of every dorm room)

[Stefano Rivera <stefanor@debian.org>]

Hi ChangZhuo (2018.08.14_03:55:36_+0200)
> * NCTU accounting office needs the start date / end date of every
>   dormitory rooms to write off NCTU budget for dormitory.

I sent you the result of this query:

SELECT room,
  min(date) as first_arrival,
  DATE(max(date) + INTERVAL '1 day') AS last_departure
FROM register_accomm
LEFT JOIN register_accomm_nights
  ON register_accomm.id = register_accomm_nights.accomm_id
LEFT JOIN register_accommnight
  ON register_accomm_nights.accommnight_id = register_accommnight.id
LEFT JOIN front_desk_checkin
  ON register_accomm.attendee_id = front_desk_checkin.attendee_id
WHERE room != ''
  AND front_desk_checkin.id IS NOT NULL
GROUP BY room
ORDER BY room;

SR

-- 
Stefano Rivera
  http://tumbleweed.org.za/
  +1 415 683 3272