CARFAX Interview Questions

CARFAX Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(46)
Machine Learning
(25)
SQL
(13)
A/B Testing
(11)
Statistics
(10)

CARFAX Interview Questions

Practice for the CARFAX interview with these recently asked interview questions.

QuestionTopicDifficulty
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:

transactions table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

Output:

Column Type
num_of_upsold_customers INTEGER
Statistics
Medium
Machine Learning
Medium
Loading pricing options

View all Carfax questions

Challenge

Check your skills...
How prepared are you for working at Carfax?

CARFAX Salaries by Position

Data Scientist*
$101K
$119K
Data Scientist
Median: $110K
Mean (Average): $110K
Data points: 2
Data Analyst*
$85K
$124K
Data Analyst
Median: $105K
Mean (Average): $105K
Data points: 2
$61K
$107K
Software Engineer
Median: $78K
Mean (Average): $82K
Data points: 6

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

?
There are no comments yet. Start the conversation by leaving a comment.