Pergunta de entrevista da empresa DHL

Technical questions: 1) what is the difference between using where and having? 2) what is the aggregation function? 3) what is inner/outer join? and describe their difference. Behavior questions: 1) describe the biggest challenge you have faced in your previous jobs. 2) what is your biggest strengths and weakness?