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:
||employee id of the survey respondant
||Will be one of the following values, 'view', 'answer', 'skip'
||ID of the question asked
||ID of the answer askedD
||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