HRE Data Archive ADQL example queries

Available 'Platforms' at the archive

Use case: I want to retrieve all the platforms

Target table: hreda.platform

Query: 
SELECT platform_name FROM hreda.platform

Available 'Categories' at the archive

Use case: I want to retrieve all the categories

Target table: hreda.hre_category

Query: 
SELECT DISTINCT hre_category_name FROM hreda.hre_category

Information about all 'Investigations'

Use case: I want to retrieve information about all investigations available at the archive

Target table: hreda.v_investigation

Query: 
SELECT investigation_name,short_description,platform_name,start_date,end_date FROM hreda.v_investigation

Available 'Investigations' at a certain category field and platform

Use case: I want to retrieve information about all investigations available at the archive where platform is 'ISS' and category is 'Biology'

Target table: hreda.v_investigation

Query: 
SELECT DISTINCT investigation_name FROM hreda.v_investigation WHERE platform_name='ISS' AND hre_category_name='Biology'