I was emailed for an on-campus interview after talking to several recruiters on campus.

The on-campus interview was very easy. Most of the questions were based on class experience and projects I had worked on in class, and it lasted about 30 minutes.

The next day, I was invited up to the SF office for an on-site interview.

This interview consisted of four 1:1, 45-minute interviews with vice-presidents from different tech departments at Aladdin.

The interviews varied depending on the person.

• One person just asked me about my class and resume experience. We ended up spending 30 minutes talking about the entire HTTP protocol and how PHP fits into the cycle, as well as the idea of the internet. It was an interesting talk but had nothing to do with programming or my experience.
• The rest of the interviews were more standard, discussing my classwork and several software questions about design patterns, SQL queries, OOP, etc.

I am writing "No Offer" because it has only been a week and I have not heard back from them yet.

Write a query that would join two tables and collapse them on one attribute.