Examples:

View the full schema or read the documentation. Download the live SQLite file here.

• select * from Sources
• select * from Sources
  where source like "%twa%"
• select * from Sources
  join Photometry
  using (source)
  where source like "%twa%"
• select * from SpectralTypes
  join Spectra using (source)
  where spectral_type_string like "%sd%"
• select * from SpectralTypes
  join Spectra using (source)
  where (spectral_type_string like "%L%" or
  spectral_type_string like "%T%" or
  spectral_type_string like "%Y%") and
  instrument like "SpeX"
• select * from Spectra
  where telescope like "JWST"
  and instrument like "NIRspec"

Note that the query backend is SQLite, be aware of any syntax differences. You can also submit queries with Ctrl+Enter.