Give the event ID, location, and status of events conducted from November 2019 to March 2020.
event_date BETWEEN '2019-11-01' and '2020-03-31'
SELECT event_id, location, status FROM event WHERE date(SUBSTR(event_date, 1, 10)) BETWEEN '2019-11-01' AND '2020-03-31'