Skip to contentSkip to footer

Lead Designer Interview Questions

Salaries
Interviews

45,142 lead designer 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 1401 - 1410 interview questions

Glassdoor has 45,142 interview questions and reports from Lead designer interviews. Prepare for your interview. Get hired. Love your job.