Evolution interview question

Explain the difference between INNER JOIN and LEFT JOIN. How do you optimize an SQL query for better performance? How do you handle NULL values in SQL queries?

Evolution Interview Question: Explain the difference between INNER JOIN and LEFT JOIN. How do you optimize an SQL query for better performance? How do you handle NULL values in SQL queries? | Glassdoor