Domanda di colloquio di Tesla

Basic knowledge of SQL, what is the difference between union and union all, difference between left join, right join and join, what is index in sql and how does it help