Allstate interview questions

Similar to what has been described before, I had a phone screen interview with two Data scientists, the questions revolved around, SQL, and general programming: find the mode of a column in SQL, find if two strings are anagrams of each other. This was then followed by a case study about a shipping container company and how to evaluate fuel efficiency. This part of the interview process was good as the people on the other end were helpful if you were confused or stuck. I was then moved forward to the virtual onsite interview. This took place at the start of June and lasted three hours, seemingly before they had decided to pull the job/move in another direction. This interview consisted of three parts, behavioural, programming, case study. It was really an expanded version of the phone interview. The programming part of the process was done on a virtual whiteboard programme with an emphasis on being as syntactically correct as possible. Two days after the interview I was emailed that I had not received the position, I wasn't entirely shocked by this, as I didn't think that I had performed that well.