Practice for the CARFAX interview with these recently asked interview questions.
| Question | Topic | Difficulty | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL | Medium | |||||||||||||||||
We’re given a table of product purchases. Each row in the table represents an individual user product purchase. Write a query to get the number of customers that were upsold, or in other words, the number of users who bought additional products after their first purchase. Note: If the customer purchased two things on the same day, that does not count as an upsell, as they were purchased within a similar timeframe. Example: Input:
Output:
| ||||||||||||||||||
Statistics | Medium | |||||||||||||||||
Machine Learning | Medium | |||||||||||||||||
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Check your skills...
How prepared are you for working at Carfax?
Most data science positions fall under different position titles depending on the actual role.
From the graph we can see that on average the Data Scientist role pays the most with a $110,000 base salary while the Software Engineer role on average pays the least with a $81,663 base salary.
Discussion & Interview Experiences