I thought the interview process was pretty professional. They brought in several candidates at the same time, I believe there were three other persons interviewing at the same time as myself. We met with different people at scheduled times, eventually meeting with all on the hiring team.

I found the experience new and different, but not necessarily negative. I did note that one of the other candidates voiced concerns about other people being present on the same day although there was no point in time where we were interviewing with the same person at the same time.

To describe how a person would write an SQL statement to get the names, locations, and something else from 3 different tables without using joins or views.