ESA HST ADQL example queries

New observations

Use case: I want to retrieve all the observations whose planes were or will be released to the public from a certain date, with the latest release dates listed first.

Target table: ehst.observation

Query: 
SELECT observation_id, release_date
FROM ehst.observation
WHERE release_date > '2020-10-01'
ORDER BY release_date DESC

Observations in a time range

Use case: I want to retrieve all the observations whose planes were or will be released to the public between two dates, with the latest release dates listed first.

Target table: ehst.observation

Query: 
SELECT observation_id, release_date
FROM ehst.observation
WHERE release_date > '2020-10-01'
AND release_date < '2020-11-01'
ORDER BY release_date DESC