The first stage it's a phone interview, then a frontal interview inside the company. During the phone interview I was asked about the java memory model, so be prepared. During the frontal interview the interviewer asked me to write some sql query on his laptop. I could use the internet, but the interviewer was watching every step.

Given my sql database contains event lot table with created date field. Using sql get count of every day events in given month from event log table.