Question 5 - Employee survey results


The following data science interview question is testing for your ability to interpret a 'real life' dataset and quickly extract an insight. This particular question asks for a solution in SQL, but it would also be common to solve this in Python or R.

You're consulting for a company, and you've sent out a survey that asks successive qustions randomly. The survey logs data into a table called survey_logging. The schema of the table is:


Column Name Data Type Description
employee_id integer employee id of the survey respondant
action string Will be one of the following values, 'view', 'answer', 'skip'
question_id integer ID of the question asked
answer_id integer ID of the answer askedD
timestamp integer time stamp of the action made by respondant

Using SQL, find which question has the highest response rate.



Ace your next data science interview

Get better at data science interviews by solving a few questions per week