SpectraMedix interview question

Normal SQL basics on how to extract data