GlobalData Interview Question

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