LeetCode 1661: Average Time of Process per Machine (SQL) | Amazon Interview Questions

In this question we need to calculate average processing time a machine takes.

Catch in this question is we have different process, So we need to calculate time take by a machine for a particular process and then calculate average time.

This question will help you in understanding self join and how to arrive at joining conditions. Interviewers love these types of question as it will help them in understanding your foundation when it comes to SQL especially if you are appearing for an analytics role.

Feel free to drop your doubts or suggestion in comments and you can also connect with us on the below mentioned WhatsApp Number and email if you need any help or guidance with respect to data science.

WhatsApp : [phone]

#sql #sqlforbeginners #leetcode #sqlinterviewquestions #database #datascience #dataanalytics #businessanalysis