Being primarily a behavioral interview the questions were primarily focused on questions where I needed to relay situations I had worked through that demonstrate my abilities and knowledge of the leadership principles. The technical questions were relatively simple regarding setting up SQL statements, creating joins, thinking critically/technically about challenges in extracting data, etc. Probably the most difficult technical question was during the phone interview when I had to, off the top of my head, tell the interviewer how to write a SQL statement without being able to type or write it out myself. This was only difficult in that all of it had to happen in my head and it included multiple tables, a sub-query, and a union.

What is the difference between inner and left join?