Python code was an ok one. One of the general question from interview preparation for coding. I was able to do the coding successfully but not able to optimise it. SQL was tough. The question was like a real scenario from HBO's business use case. Something which needs time to analyse and find. Didn't expect such kind of question for an interview though. Few questions on big data and cloud services. I had some hope after the interview process but was not through :)