Roofstock Interview Questions

Roofstock Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(15)
Statistics
(5)
SQL
(5)
Data Modeling
(4)
Machine Learning
(4)

Roofstock Interview Questions

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

QuestionTopicDifficulty
SQL
Medium

Given the employees and departments table, write a query to get the top 3 highest employee salaries by department. If the department contains less that 3 employees, the top 2 or the top 1 highest salaries should be listed (assume that each department has at least 1 employee). 

Note: The output should include the full name of the employee in one column, the department name, and the salary. The output should be sorted by department name in ascending order and salary in descending order. 

Example:

Input:

employees table

Column Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Column Type
id INTEGER
name VARCHAR

Output:

Column Type
employee_name VARCHAR
department_name VARCHAR
salary INTEGER
SQL
Easy
SQL
Easy
Loading pricing options

View all Roofstock questions

Challenge

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

Roofstock Salaries by Position

Data Scientist*
$125K
Data Scientist
Median: $125K
Mean (Average): $125K
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 Data Scientist role pays the most with a $125,000 base salary while the Data Scientist role on average pays the least with a $125,000 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