GlobalData interview question

Advanced computer project; SQL questions: having group by and where ....