Egnyte interview question

2) Three SQL coding questions were based on joins and aggregate functions,where and having clauses