SmartNews Interview Questions

SmartNews Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(31)
SQL
(25)
Probability
(24)
Machine Learning
(24)
Product Sense & Metrics
(22)

SmartNews Interview Questions

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

QuestionTopicDifficulty
SQL
Easy

We’re given two tables, a users table with demographic information and the neighborhood they live in and a neighborhoods table.

Write a query that returns all neighborhoods that have 0 users. 

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
neighborhood_id INTEGER
created_at DATETIME

neighborhoods table

Columns Type
id INTEGER
name VARCHAR
city_id INTEGER

Output:

Columns Type
name VARCHAR
SQL
Medium
A/B Testing
Medium
Loading pricing options

View all Smartnews questions

Challenge

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

SmartNews Salaries by Position

$210K
$324K
Software Engineer
Median: $220K
Mean (Average): $242K
Data points: 5
ML Engineer*
$210K
ML Engineer
Median: $210K
Mean (Average): $210K
Data points: 2
Product Manager*
$200K
Product Manager
Median: $200K
Mean (Average): $200K
Data points: 1
Data Scientist*
$190K
Data Scientist
Median: $190K
Mean (Average): $190K
Data points: 1
Business Analyst*
$155K
Business Analyst
Median: $155K
Mean (Average): $155K
Data points: 2

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Software Engineer role pays the most with a $242,000 base salary while the Business Analyst role on average pays the least with a $155,000 base salary.

Discussion & Interview Experiences

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