I was interviewed as a fresher directly from college. The interview process was split into several stages: a technical interview, followed by an HR interview. I was tested on my technical expertise, not just in the specific area they were looking for, but also on my overall knowledge, as well as my learning aptitude for new technologies and training (perhaps because I was a fresher).

To write an SQL query to get the current price of an item in a state, based on three different tables. These tables have a many-to-many relationship, with the price table containing a history of prices as well as potential future prices.