DS at Paypal; DA at Google

Excellent preparatory tool, thanks!

The interview was very helpful

Thanks again for collaborating. This is really useful. You have been very helpful with my preparation.

Thank you for taking time mock interview with me.

The expert clearly explained the agenda and the structure of the interview and covered almost all the topics. The interviewer gave more than his 100%. The questions and feedback helped me to feel more prepared. The expert clearly explained the agenda and the structure of the interview and covered almost all the topics. The interviewer gave more than his 100%. The questions and feedback helped me to feel more prepared.

Thank you for your time. It was very helpful

It was good

Thank you for your detailed feedback. It really helps me to understand which areas I should focus on to improve myself and get prepared for the interview. It gives an idea of what to expect in a real interview and prepares you accordingly.

I was able to find the window function use for question four... select prod_id, sale_year, sales, previous_year_sales from ( select prod_id, sale_year, sum(price * quantity) as sales, lag(sum(price * quantity),1) over(order by sale_year) as previous_year_sales, lag(sale_year,1) over(order by sale_year) as previous_year from testing.product_sales group by sale_year, prod_id) as t1 where sales > previous_year_sales and previous_year = 2011 and sale_year = 2012 I enjoyed the experience and the interviewer did a great job and gave great feedback.