Interviewer was informative but given me very less time for the SQL live coding. I was asked to remove duplicates and group variables and merge. Finally find the second max. Interviewer helped through interview and cooperated with me.