Domanda di colloquio di Siemens

What's the difference between an Inner join and an Outer Join? Difference between WHERE and HAVING SQL commands. Which type of visualizations would u use for particular scenarios.