Société Générale interview question

Difference between where and having Diff b/w group by and windows function Error Handling In SP Trigger Function Diff between SP and Function Windows function Odd rows in 50 empid Inner join two tables with nulls