Here Interview Questions

Here Interview Guides

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

Here Interview Questions

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

QuestionTopicDifficulty
SQL
Medium

Write a SQL query to create a histogram of the number of comments per user in the month of January 2020.

Note: Assume bin buckets class intervals of one.

Note: Comments that were created outside of January 2020 should be counted in a “0” bucket

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
created_at DATETIME
neighborhood_id INTEGER
mail VARCHAR

comments table

Columns Type
user_id INTEGER
body VARCHAR
created_at DATETIME

Output:

Column Type
comment_count INTEGER
frequency INTEGER
Data Structures & Algorithms
Easy
SQL
Medium
Loading pricing options

View all Here questions

Challenge

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

Here Salaries by Position

$70K
$726K
Product Manager
Median: $115K
Mean (Average): $325K
Data points: 3
ML Engineer*
$81K
$229K
ML Engineer
Median: $155K
Mean (Average): $155K
Data points: 2
Data Engineer*
$78K
$165K
Data Engineer
Median: $122K
Mean (Average): $122K
Data points: 2
$95K
$123K
AI Research Scientist
Median: $107K
Mean (Average): $109K
Data points: 22
$65K
$127K
Data Scientist
Median: $100K
Mean (Average): $99K
Data points: 29
$52K
$191K
Software Engineer
Median: $88K
Mean (Average): $98K
Data points: 78
$75K
$93K
Business Analyst
Median: $84K
Mean (Average): $84K
Data points: 10
Data Analyst*
$51K
Data Analyst
Median: $51K
Mean (Average): $51K
Data points: 1

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

From the graph we can see that on average the Product Manager role pays the most with a $324,667 base salary while the Data Analyst role on average pays the least with a $50,856 base salary.

Discussion & Interview Experiences

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

Discussion & Interview Experiences

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

Jump to Discussion