Skip to contentSkip to footer

Lead Analyst Interview Questions

Salaries
Interviews

16,136 lead analyst interview questions shared by candidates

6) We'd like to better understand the preferences of a segment of movie watching users. We are particularly interested in those users who have an occupation of 'Engineer'. For these 'Engineer' users, we want to know more about their favorite movies - the top five rated movies (where a rating of 5 is the best). We would like to consider only those movies which have a significant amount of ratings, so let's say at least 20 Engineers must have rated a movie for the movie to be considered in the top 5. So, in summary, write a query to return the top 5 significant movies as rated by 'Engineers'.
avatar

QA Team Lead

Interviewed at Instacart

3.6★
Aug 1, 2019

6) We'd like to better understand the preferences of a segment of movie watching users. We are particularly interested in those users who have an occupation of 'Engineer'. For these 'Engineer' users, we want to know more about their favorite movies - the top five rated movies (where a rating of 5 is the best). We would like to consider only those movies which have a significant amount of ratings, so let's say at least 20 Engineers must have rated a movie for the movie to be considered in the top 5. So, in summary, write a query to return the top 5 significant movies as rated by 'Engineers'.

Viewing 1181 - 1190 interview questions

Glassdoor has 16,136 interview questions and reports from Lead analyst interviews. Prepare for your interview. Get hired. Love your job.