Blue Yonder interview question

Basic Questions on DL SQL- Joins, Groupby - Having